SQL•SQL References

SQL Server SYSDATETIME() Function

Example

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()

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

Loading lesson path

SQL•SQL References

Example

SELECT SYSDATETIME() AS SysDateTime;

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

Syntax

SYSDATETIME()

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