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!
This exercise is part of the course
Data Types and Functions in Snowflake
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT
-- Return '2007-06-13' as a DATE
___('___') AS the_date
;