CURRENT_DATE

Date function

Description

CURRENT_DATE returns a date in the current session time zone (UTC by default) in the default format: YYYY-MM-DD. (RedShift SQL Language Reference CURRENT_DATE)

Grammar Syntax

CURRENT_DATE

Sample Source Patterns

Input Code:

Redshift

IN -> Redshift_01.sql

SELECT CURRENT_DATE;

Result

DATE
2024-09-22

Output Code:

Snowflake

OUT -> Redshift_01.sql

SELECT
    CURRENT_DATE();

Result

DATE_T
2024-09-22

Recommendations

There are no recommendations.

Related EWIs

There are no known issues.