CURRENT_TIMESTAMP

Returns the current system timestamp (as defined on the computer on which SQLstream s-Server is running) as a TIMESTAMP value. The timestamp is always returned as UTC (GMT).

Like all the standard SQL date/time functions, this function returns the same value - the timestamp when the query started (actually, when the first row is processed) - for every row processed. A streaming query may run for minutes, hours, days or even years; if you want to return the latest time when each row is processed you should instead use CURRENT_ROW_TIMESTAMP.

See also:

Example

0: jdbc:sqlstream:> values current_timestamp;
+---------------------+
|  CURRENT_TIMESTAMP  |
+---------------------+
| 2020-12-12 14:50:36.378 |
+---------------------+