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()
Return the date and time of the SQL Server:
SELECT SYSDATETIME() AS SysDateTime;
The SYSDATETIME() function returns the date and time of the computer where the SQL Server is running.
SYSDATETIME()