Amazon Kinesis Data Analytics
SQL Reference

LOCALTIMESTAMP

Returns the current timestamp as defined by the environment on Amazon Kinesis Data Analytics application is running. Time is always returned as UTC (GMT), not the local timezone.

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

Example

values localtimestamp; +--------------------------+ |      LOCALTIMESTAMP      | +--------------------------+ | 2008-08-27 01:13:42.206  | +--------------------------+ 1 row selected (1.133 seconds)

Limitations

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

On this page: