SQL Server SYSDATETIME() Function

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.

SYSDATETIME()

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