How to: |
The CURRENT_TIMESTAMP function returns the current timestamp of the operating system (date and time) in the form YYYYMMDDHHMMSS. You may specify the number of decimal places for fractions of a second--0, 3, or 6 places. Six (6) places is the default.
CURRENT_TIMESTAMP[(precision)]
where:
Integer constant
Is the number of decimal places for fractions of a second. Possible values are 0, 3, and 6.
This function returns a timestamp (format: HYYMDS if no decimal places; HYYMDs if 3 decimal places; HYYMDm if 6 decimal places).
At 2:11:23 PM on October 9, 2005:
CURRENT_TIMESTAMP returns 20051009141123000000.
CURRENT_TIMESTAMP(0) returns 20051009141123.
CURRENT_TIMESTAMP(3) returns 20051009141123000.
CURRENT_TIMESTAMP(6) returns 20051009141123000000.
iWay Software |