ASA SQL Reference
SQL Language Elements
Special values
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.
TIMESTAMP
TIMESTAMP data type [Date and Time]
GETDATE function [Date and time]