CURRENT_DATE

<< Click to Display Table of Contents >>

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

CURRENT_DATE

Previous pageReturn to chapter overviewNext page

Returns the current date as YYYY-MM-DD when the query executes as defined by the computer on which the SQLstream s-Server is running.

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

Example

0: jdbc:sqlstream:> values current_date;

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

| CURRENT_DATE  |

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

| 2008-08-27    |

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