Returns the value of the current timestamp data type for the current database. This timestamp is guaranteed to be unique in the database.

Syntax

@@DBTS

Return Types

varbinary

Remarks

@@DBTS returns the current database's last-used timestamp value. A new timestamp value is generated when a row with a timestamp column is inserted or updated.

Examples

This example returns the current timestamp from the pubs database.

USE pubs
SELECT @@DBTS

See Also