Neoview SQL Reference Manual (R2.4 SP2)

CURRENT_TIMESTAMP Function
The CURRENT_TIMESTAMP function returns a value of type TIMESTAMP based on the current
local date and time.
The function is evaluated once when the query starts execution and is not reevaluated (even if
it is a long running query).
You can also use the “CURRENT Function” (page 361).
CURRENT_TIMESTAMP [(precision)]
precision
is an integer value in the range 0 to 6 that specifies the precision of (the number of decimal
places in) the fractional seconds in the returned value. The default is 6.
For example, the function CURRENT_TIMESTAMP (2) returns the current date and time as
a value of data type TIMESTAMP, where the precision of the fractional seconds is 2; for
example, 2008-06-26 09:01:20.89. The value returned is not a string value.
Example of CURRENT_TIMESTAMP
The PROJECT table contains a column SHIP_TIMESTAMP of data type TIMESTAMP. Update
a row by using the CURRENT_TIMESTAMP value:
UPDATE persnl.project
SET ship_timestamp = CURRENT_TIMESTAMP
WHERE projcode = 1000;
CURRENT_TIMESTAMP Function 365