Breaking down a timestamp
Your development team is after you again! They'd like the data that a user checked into the gym in a certain format so they can expose it in the app. In this exercise, you'll use Snowflake to extract different components of a timestamp to provide this information!
Diese Übung ist Teil des Kurses
Data Types and Functions in Snowflake
Interaktive Übung
Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.
SELECT
v.user_id,
m.user_location,
v.checkin_time,
-- Extract the day name from checkin_time
___(___) AS day_name
FROM CORE_GYM.visits AS v
JOIN CORE_GYM.members AS m
ON v.user_id = m.user_id;