SYSUTCDATETIME

Applies to

Description

Returns a datetime2(7) value that contains the date and time of the computer on which the instance of SQL Server is running. ().

SYSUTCDATETIME ( )

SYSDATE()

Code:

IN -> SqlServer_01.sql

SELECT SYSUTCDATETIME() as SYS_UTC_DATETIME;

Result:

SYSTEM_UTC_DATETIME        |
---------------------------+
2023-02-02 20:59:28.0926502|

Code:

OUT -> SqlServer_01.sql

SELECT
SYSDATE() as SYS_UTC_DATETIME;

Result:

SYSTEM_UTC_DATETIME      |
-------------------------+
2023-02-02 21:02:05.557  |

No issues were found.

No related EWIs.

Last updated 2 months ago