CURRENT_TIME

Returns the current time (as a TIME) when the query starts as defined by the computer on which the SQLstream s-Server is running.

Like all the standard SQL date/time functions, this function returns the same value - the time 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:

    SELECT ..., CAST(CURRENT_ROW_TIMESTAMP AS TIME) AS current_date, ... FROM ...

See also:

Example

0: jdbc:sqlstream:> values current_time;
+--------------+
| CURRENT_TIME |
+--------------+
| 14:49:07     |
+--------------+