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!
Это упражнение является частью курса
Data Types and Functions in Snowflake
Интерактивное практическое упражнение
Попробуйте выполнить это упражнение, дополнив этот пример кода.
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;