Returns the value of the current timestamp data type for the current database. This timestamp is guaranteed to be unique in the database.
Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Database.
The following example returns the current timestamp from the AdventureWorks2012 database.
USE AdventureWorks2012; GO SELECT @@DBTS;