| title | @@TIMETICKS (Transact-SQL) | Microsoft Docs | |||||
|---|---|---|---|---|---|---|
| ms.custom | ||||||
| ms.date | 09/18/2017 | |||||
| ms.prod | sql | |||||
| ms.prod_service | sql-database | |||||
| ms.reviewer | ||||||
| ms.suite | sql | |||||
| ms.technology | t-sql | |||||
| ms.tgt_pltfrm | ||||||
| ms.topic | language-reference | |||||
| f1_keywords |
|
|||||
| dev_langs |
|
|||||
| helpviewer_keywords |
|
|||||
| ms.assetid | 9d036633-837f-4309-9c45-3d9600258018 | |||||
| caps.latest.revision | 28 | |||||
| author | MashaMSFT | |||||
| ms.author | mathoma | |||||
| manager | craigg |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]
Returns the number of microseconds per tick.
Transact-SQL Syntax Conventions
@@TIMETICKS
integer
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.
SELECT @@TIMETICKS AS 'Time Ticks';