CommencerCommencer gratuitement

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!

Cet exercice fait partie du cours

Data Types and Functions in Snowflake

Afficher le cours

Instructions

  • 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.

Exercice interactif pratique

Essayez cet exercice en complétant cet exemple de code.

SELECT
    checkin_time,
    
    -- Cast checkin_time to DATE
    ___::___ AS the_date,
    
    -- Cast checkin_time to TIME
    ___::___ AS the_time

    
FROM CORE_GYM.visits
;
Modifier et exécuter le code