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!
Bu egzersiz
Data Types and Functions in Snowflake
kursunun bir parçasıdırEgzersiz talimatları
- 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.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
SELECT
checkin_time,
-- Cast checkin_time to DATE
___::___ AS the_date,
-- Cast checkin_time to TIME
___::___ AS the_time
FROM CORE_GYM.visits
;