CURRENT_DATE function - Amazon Redshift

CURRENT_DATE function

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

Note

CURRENT_DATE returns the start date for the current transaction, not for the start of the current statement.

Syntax

CURRENT_DATE

Return type

DATE

Examples

The following example returns the current date.

select current_date; date ------------ 2008-10-01 (1 row)