CURRENT_DATE

Returns the current date (as a DATE) when the query starts as defined by the computer on which the SQLstream s-Server is running. The date is always based on UTC (GMT).

Like all the standard SQL date/time functions, this function returns the same value - the date 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 date at the time each row is processed you should instead use:

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

See also:

Example

0: jdbc:sqlstream:> values current_date;
+---------------+
| CURRENT_DATE  | 
+---------------+
| 2020-08-27    | 
+---------------+