View a markdown version of this page

⭐ Must Read: kinesisanalytics/latest/sqlref/sql reference current date.html - Kapook Update 2025

CURRENT_DATE

Returns the current Amazon Kinesis Data Analytics system date when the query executes as YYYY-MM-DD when the query executes.

For more information, see CURRENT_TIME, CURRENT_TIMESTAMP, LOCALTIMESTAMP, LOCALTIME, and CURRENT_ROW_TIMESTAMP.

Example

+---------------+ | CURRENT_DATE  | +---------------+ | 2008-08-27    | +---------------+