LOCALTIME - Amazon Kinesis Data Analytics SQL Reference

LOCALTIME

Returns the current time when the query executes as defined by the environment on which Amazon Kinesis Data Analytics is running. LOCALTIME is always returned as UTC (GMT), not the local timezone.

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

Example

VALUES localtime; +------------+ | LOCALTIME  | +------------+ | 01:11:15   | +------------+ 1 row selected (1.558 seconds)

Limitations

Amazon Kinesis Data Analytics does not support the optional <time precision> parameter specified in SQL:2008. This is a departure from the SQL:2008 standard.