When did you check in?
Not only can you convert strings to datetime values, you can also manipulate these values themselves. Your manager has tasked you with further breaking down the date and time that gym members visit a certain location. Time to get to it!
Latihan ini adalah bagian dari kursus
Data Types and Functions in Snowflake
Petunjuk latihan
- Update this query to cast the
checkin_timecolumn to aDATEstored in a column calledthe_date. - Add a final line to the
SELECTstatement to castcheckin_timeto aTIMEdata type and alias the resulting column asthe_time.
Latihan interaktif praktis
Cobalah latihan ini dengan menyelesaikan kode contoh berikut.
SELECT
checkin_time,
-- Cast checkin_time to DATE
___::___ AS the_date,
-- Cast checkin_time to TIME
___::___ AS the_time
FROM CORE_GYM.visits
;