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!
Diese Übung ist Teil des Kurses
Data Types and Functions in Snowflake
Anleitung zur Übung
- 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.
Interaktive Übung
Vervollständige den Beispielcode, um diese Übung erfolgreich abzuschließen.
SELECT
checkin_time,
-- Cast checkin_time to DATE
___::___ AS the_date,
-- Cast checkin_time to TIME
___::___ AS the_time
FROM CORE_GYM.visits
;