LOCALTIMESTAMP

<< Click to Display Table of Contents >>

Navigation:  Streaming SQL Reference Guide > Basic Building Blocks > Functions > Time Functions >

LOCALTIMESTAMP

Previous pageReturn to chapter overviewNext page

Returns the current timestamp as defined by the computer on s-Server is running. Time is always returned as UTC (GMT), not the local timezone.

See also CURRENT_TIME, CURRENT_DATE, CURRENT_TIMESTAMP, LOCALTIME, CURRENT_ROW_TIMESTAMP.

Example

0: jdbc:sqlstream:> values localtimestamp;

+--------------------------+

|      LOCALTIMESTAMP      |

+--------------------------+

| 2008-08-27 01:13:42.206  |

+--------------------------+

1 row selected (1.133 seconds)

Limitations

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