Skip to content

timeticks-transact-sql.md

Latest commit

 

History

History
54 lines (42 loc) · 1.46 KB

timeticks-transact-sql.md

File metadata and controls

54 lines (42 loc) · 1.46 KB
title @@TIMETICKS (Transact-SQL) | Microsoft Docs
ms.custom
ms.date 09/18/2017
ms.prod sql
ms.prod_service sql-database
ms.reviewer
ms.technology t-sql
ms.topic language-reference
f1_keywords
@@TIMETICKS_TSQL
@@TIMETICKS
dev_langs
TSQL
helpviewer_keywords
ticks [SQL Server]
@@TIMETICKS function
microseconds per tick [SQL Server]
time [SQL Server], ticks
number of microseconds per tick
ms.assetid 9d036633-837f-4309-9c45-3d9600258018
author MikeRayMSFT
ms.author mikeray

@@TIMETICKS (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

Returns the number of microseconds per tick.

Topic link icon 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';

See Also

System Statistical Functions (Transact-SQL)