NOW scalar function

The NOW function returns a timestamp based on a reading of the time-of-day clock when the SQL statement is executed at the current server.

Read syntax diagramSkip visual syntax diagramNOW( 6integer )

The schema is SYSIBM.

integer
Specifies the precision of the timestamp. Valid values are 0 to 12, inclusive. If you do not specify an integer, the default precision of 6 is used.

The value returned by the NOW function is the same as the value returned by the CURRENT TIMESTAMP special register. If this function is used more than once within a single SQL statement or used with CURRENT DATE, CURRENT TIME, or CURRENT TIMESTAMP special registers within a single statement, all values are based on a single clock reading.

The precision of the clock reading varies by platform and the resulting value is padded with zeros if the precision of the retrieved clock reading is less than the precision of the request.

The data type of the result is a timestamp. The result cannot be null.

Example

Return the timestamp for the current time.
values now().   
			Result: 2015-04-01-03.17.04.579645.