Cast to DATE using { }

Transflation specification for casts of literal strings to date using curly braces to Snowflake

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

Description

The following syntax casts a date-formatted string to DATE datatype by putting a d before the string definition inside curly braces.

SELECT {d '1233-10-10'}

Sample Source Patterns

Cast to DATE using curly braces

Teradata

Cast to Date

SELECT * FROM RESOURCE_DETAILS where change_ts >= {d '2022-09-10'};

Snowflake

Cast to Date

SELECT
* FROM
PUBLIC.RESOURCE_DETAILS
where change_ts >= DATE('2022-09-10');