Skip to content

current-timestamp-transact-sql.md

Latest commit

 

History

History
144 lines (118 loc) · 5.05 KB

current-timestamp-transact-sql.md

File metadata and controls

144 lines (118 loc) · 5.05 KB

title: "CURRENT_TIMESTAMP (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "07/24/2017" ms.prod: "sql" ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw" ms.service: "" ms.component: "t-sql|functions" ms.reviewer: "" ms.suite: "sql" ms.technology:

  • "database-engine" ms.tgt_pltfrm: "" ms.topic: "language-reference" f1_keywords:
  • "CURRENT_TIMESTAMP"
  • "CURRENT_TIMESTAMP_TSQL" dev_langs:
  • "TSQL" helpviewer_keywords:
  • "dates [SQL Server], functions"
  • "niladic functions"
  • "current date and time [SQL Server]"
  • "time [SQL Server], current"
  • "date and time [SQL Server], CURRENT_TIMESTAMP"
  • "functions [SQL Server], time"
  • "system date and time [SQL Server]"
  • "system time [SQL Server]"
  • "functions [SQL Server], date and time"
  • "time [SQL Server], functions"
  • "dates [SQL Server], current date and time"
  • "dates [SQL Server], system date and time"
  • "CURRENT_TIMESTAMP function [SQL Server]"
  • "time [SQL Server], system" ms.assetid: c724d9cc-7b1f-4c71-bdf5-08bc52b33afc caps.latest.revision: 48 author: "edmacauley" ms.author: "edmaca" manager: "craigg" monikerRange: ">= aps-pdw-2016 || = azuresqldb-current || = azure-sqldw-latest || >= sql-server-2016 || = sqlallproducts-allversions"

CURRENT_TIMESTAMP (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-all-md]

Returns the current database system timestamp as a datetime value without the database time zone offset. This value is derived from the operating system of the computer on which the instance of [!INCLUDEssNoVersion] is running.

Note

SYSDATETIME and SYSUTCDATE have more fractional seconds precision than GETDATE and GETUTCDATE. SYSDATETIMEOFFSET includes the system time zone offset. SYSDATETIME, SYSUTCDATE, and SYSDATETIMEOFFSET can be assigned to a variable of any of the date and time types.

This function is the ANSI SQL equivalent to GETDATE.

For an overview of all [!INCLUDEtsql] date and time data types and functions, see Date and Time Data Types and Functions.

Topic link icon Transact-SQL Syntax Conventions

Syntax

CURRENT_TIMESTAMP

Arguments

Takes no arguments.

Return Type

datetime

Remarks

[!INCLUDEtsql] statements can refer to CURRENT_TIMESTAMP anywhere they can refer to a datetime expression.

CURRENT_TIMESTAMP is a nondeterministic function. Views and expressions that reference this column cannot be indexed.

Examples

The following examples use the six [!INCLUDEssNoVersion] system functions that return current date and time to return the date, the time, or both. The values are returned in series so their fractional seconds might differ.

A. Get the Current System Date and Time

SELECT SYSDATETIME()  
    ,SYSDATETIMEOFFSET()  
    ,SYSUTCDATETIME()  
    ,CURRENT_TIMESTAMP  
    ,GETDATE()  
    ,GETUTCDATE();  
/* Returned:  
SYSDATETIME()      2007-04-30 13:10:02.0474381  
SYSDATETIMEOFFSET()2007-04-30 13:10:02.0474381 -07:00  
SYSUTCDATETIME()   2007-04-30 20:10:02.0474381  
CURRENT_TIMESTAMP  2007-04-30 13:10:02.047  
GETDATE()          2007-04-30 13:10:02.047  
GETUTCDATE()       2007-04-30 20:10:02.047

B. Get the Current System Date

SELECT CONVERT (date, SYSDATETIME())  
    ,CONVERT (date, SYSDATETIMEOFFSET())  
    ,CONVERT (date, SYSUTCDATETIME())  
    ,CONVERT (date, CURRENT_TIMESTAMP)  
    ,CONVERT (date, GETDATE())  
    ,CONVERT (date, GETUTCDATE());  
  
/* Returned   
SYSDATETIME()      2007-05-03  
SYSDATETIMEOFFSET()2007-05-03  
SYSUTCDATETIME()   2007-05-04  
CURRENT_TIMESTAMP  2007-05-03  
GETDATE()          2007-05-03  
GETUTCDATE()       2007-05-04  
*/

C. Get the Current System Time

SELECT CONVERT (time, SYSDATETIME())  
    ,CONVERT (time, SYSDATETIMEOFFSET())  
    ,CONVERT (time, SYSUTCDATETIME())  
    ,CONVERT (time, CURRENT_TIMESTAMP)  
    ,CONVERT (time, GETDATE())  
    ,CONVERT (time, GETUTCDATE());  
  
/* Returned  
SYSDATETIME()      13:18:45.3490361  
SYSDATETIMEOFFSET()13:18:45.3490361  
SYSUTCDATETIME()   20:18:45.3490361  
CURRENT_TIMESTAMP  13:18:45.3470000  
GETDATE()          13:18:45.3470000  
GETUTCDATE()       20:18:45.3470000  
*/

Examples: [!INCLUDEssSDWfull] and [!INCLUDEssPDW]

SELECT CURRENT_TIMESTAMP;

See also

CAST and CONVERT (Transact-SQL)