Cast to DATE using { }

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

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');