Exercise

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!

Instructions

100 XP

Update this query to cast the checkin_time column to a DATE stored in a column called the_date.
Add a final line to the SELECT statement to cast checkin_time to a TIME data type and alias the resulting column as the_time.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions

Exercise