CURRENT_TIMESTAMP: Obtaining the Timestamp (Date/Time)

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.


Top of page

x
Syntax: How to Obtain the Current Timestamp
CURRENT_TIMESTAMP[(precision)]

where:

precision

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).



Example: Obtaining the Current Timestamp

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