NOW

The NOW function returns the current date and time as a   TIMESTAMP value.

Syntax

NOW();

Results

Returns the current date and time as a TIMESTAMP value.

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.

Examples

splice> VALUES( NOW(), HOUR(NOW), MINUTE(NOW), SECOND(NOW) );
1                            |2          |3          |4
----------------------------------------------------------------------------
2015-11-12 17:48:55.217      |17         |48         |55.217

1 row selected

See Also