SQL Server SYSDATETIME() Function
Example
Return the date and time of the SQL Server:
SELECT SYSDATETIME() AS SysDateTime;
Try it Yourself »
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 |