Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

@@DBTS (Transact-SQL)

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

Topic link iconTransact-SQL Syntax Conventions



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

The following example returns the current timestamp from the AdventureWorks database.

USE AdventureWorks;
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft