1. Learn
  2. /
  3. Courses
  4. /
  5. Data Types and Functions in Snowflake

Connected

Exercise

Breaking down a timestamp

Your development team is after you again! They'd like the data that a user checked into the gym in a certain format so they can expose it in the app. In this exercise, you'll use Snowflake to extract different components of a timestamp to provide this information!

Instructions 1/3

undefined XP
    1
    2
    3
  • Extract the day name from checkin_time.