SYSDATETIME
Description
Returns a datetime2(7) value that contains the date and time of the computer on which the instance of SQL Server is running. (SYSDATETIME in Transact-SQL).
Sample Source Pattern
Syntax
SYSDATETIME ( )
Examples
Code:
SELECT SYSDATETIME ( ) AS SYSTEM_DATETIME;
Result:
SYSTEM_DATETIME |
-----------------------+
2022-05-06 12:08:05.501|
Last updated