DATE

Date function

Description

This function converts an input expression to a date.

This function is fully supported in Snowflake.

For more information about quoted identifiers in functions, click here.

Grammar Syntax

DATE(<expr>)

Sample Source Patterns

Input Code:

Redshift

IN -> Redshift_01.sql

SELECT DATE('2024-02-02 04:05:06.789');

SELECT "DATE"("GETDATE"());

SELECT "date"('2024-02-02 04:05:06.789');

Result

DATE('2024-02-02 04:05:06.789')
2024-02-02

"DATE"("GETDATE"())
2024-11-20

"date"('2024-02-02 04:05:06.789')
2024-02-02

Output Code:

Snowflake

OUT -> Redshift_01.sql

SELECT DATE('2024-02-02 04:05:06.789');

SELECT DATE(GETDATE());

SELECT DATE('2024-02-02 04:05:06.789');

Result

DATE('2024-02-02 04:05:06.789')
2024-02-02

"DATE"("GETDATE"())
2024-11-20

"DATE"('2024-02-02 04:05:06.789')
2024-02-02

Known Issues

No issues were found.

Related EWIs

There are no known issues.