AWS Documentation » Amazon Redshift » Database Developer Guide » SQL Reference » SQL Functions Reference » Date and Time Functions » CURRENT_DATE Function

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

Return the current date:

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