Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to:
SQL Server
Azure SQL Managed Instance
Returns the number of microseconds per tick.
Transact-SQL syntax conventions
Syntax
@@TIMETICKS
Return Types
integer
Remarks
The amount of time per tick is computer-dependent. Each tick on the operating system is 31.25 milliseconds, or one thirty-second of a second.
Examples
SELECT @@TIMETICKS AS 'Time Ticks';