Contents Index CURRENT TIME special value CURRENT USER special value

ASA SQL Reference
  SQL Language Elements
    Special values

CURRENT TIMESTAMP special value


Function 

Combines CURRENT DATE and CURRENT TIME to form a TIMESTAMP value containing the year, month, day, hour, minute, second and fraction of a second. The fraction of a second is stored to 3 decimal places. The accuracy is limited by the accuracy of the system clock.

The information CURRENT TIMESTAMP returns is equivalent to the information returned by the GETDATE and NOW functions.

Data type 

TIMESTAMP

See also 

CURRENT TIME special value

Expressions

TIMESTAMP data type [Date and Time]

GETDATE function [Date and time]

NOW function [Date and time]


Contents Index CURRENT TIME special value CURRENT USER special value