@@DBTS

[sukishan]

@@DBTS
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

[pradeep prem]

dbts has data type for the current database

they have syntax and return type with best example

this gives us with best explanation with this website easily get detail