SQL SYSDATETIME Function

Example

Return the date and time of the SQL Server:

SELECT SYSDATETIME() AS SysDateTime;

Definition and Usage

The SYSDATETIME() function returns the date and time of the computer where the SQL Server is running.

Syntax

SYSDATETIME()

Technical Details

Return type: datetime2(7)
Works in: SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse