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 | +---------------+