SQL Server SYSDATETIME() Function

Posted by

SQL Server

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

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