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

Connected

Exercise

Building datetime values

When working with datetime data in Snowflake values will often come in the form of a string. It's important to be able to convert these strings into DATE, TIME, or TIMESTAMP data types. Here, you'll practice exactly this!

Instructions 1/3

undefined XP
    1
    2
    3
  • Update the SELECT statement to return '2007-06-13' as a value of type DATE.