SQL SYSUTCDATETIME Function

SYSUTCDATETIME returns the current UTC datetime on the database server.

This function can be used as the default value for DATETIME columns.

SYSUTCDATETIME is equivalent to GETUTCDATE.

Example

#

This example returns the current UTC datetime on the database server.

SELECT SYSUTCDATETIME() AS 'Now'
Result:  1 record
Now
2021-12-02 22:11:20.5616079

Syntax

Syntax of the SYSUTCDATETIME function.

SYSUTCDATETIME()

System Datetime

SQL Server supports 6 system datetime functions.

 SELECT CURRENT_TIMESTAMP AS 'CURRENT_TIMESTAMP',
        SYSDATETIME() AS 'SYSDATETIME',
        SYSDATETIMEOFFSET() AS 'SYSDATETIMEOFFSET',  
        SYSUTCDATETIME() AS 'SYSUTCDATETIME', 
        GETDATE() AS 'GETDATE',
        GETUTCDATE() AS 'GETUTCDATE'
Result:
Function Result
CURRENT_TIMESTAMP 2021-09-12 18:14:15.007
SYSDATETIME() 2021-09-12 18:14:15.0077586
SYSDATETIMEOFFSET() 2021-09-12 18:14:15.0077586 -05:00
SYSUTCDATETIME() 2021-09-12 23:14:15.0077586
GETDATE() 2021-09-12 18:14:15.007
GETUTCDATE() 2021-09-12 23:14:15.007

The results differ in microsecond precision and datetime offset values.


You may also like



Guides


vsn 3.1