CURRENT_TIMESTAMP

CURRENT_TIMESTAMP returns the current timestamp.

This function returns the same value if it is executed more than once in a single statement, which means that the value is fixed, even if there is a long delay between fetching rows in a cursor.

Splice Machine displays TIME and TIMESTAMP values using the current time zone for the server to which you are connected. DATE values, however, are stored as fixed strings, and are not affected by the time zone of the server to which you are connected.

Syntax

CURRENT_TIMESTAMP

or, alternately

CURRENT TIMESTAMP

Results

A timestamp value.

Examples

splice> VALUES CURRENT_TIMESTAMP;
1
-----------------------------
2015-11-19 11:03:44.095

1 row selected

See Also