CURRENT TIMESTAMP special value

Combines CURRENT DATE and CURRENT TIME to form a TIMESTAMP value containing the year, month, day, hour, minute, second, and fraction of a second.

Data type

TIMESTAMP

Remarks

The fraction of a second is stored to 3 decimal places. The accuracy is limited by the accuracy of the system clock.

Columns declared with DEFAULT CURRENT TIMESTAMP do not necessarily contain unique values.

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

CURRENT_TIMESTAMP is equivalent to CURRENT TIMESTAMP.

The returned date is based on a reading of the system clock when the SQL statement is executed by the UltraLite runtime. If you use CURRENT TIMESTAMP with any of the following, all values are based on separate clock readings:

  • CURRENT TIMESTAMP multiple times within the same statement
  • CURRENT TIMESTAMP with CURRENT DATE or CURRENT TIME within a single statement
  • CURRENT TIMESTAMP with the NOW function or GETDATE function within a single statement
See also