Last updated 3 months ago
SQL Server
Azure Synapse Analytics
Returns a datetime2(7) value that contains the date and time of the computer on which the instance of SQL Server is running. ().
SYSDATETIME ( )
LOCALTIME()
Code:
SELECT SYSDATETIME ( ) AS SYSTEM_DATETIME;
Result:
SYSTEM_DATETIME | -----------------------+ 2022-05-06 12:08:05.501|
SELECT LOCALTIME ( ) AS SYSTEM_DATETIME;
SYSTEM_DATETIME | -----------------------+ 211:09:14 |
No issues were found.
No related EWIs.