GETUTCDATE
returns the current datetime on the database server.
The returned value represents current time in the UTC timezone.
GETUTCDATE
can be used as the default value for DATETIME columns.
This example returns the current UTC datetime on the database server.
SELECT GETUTCDATE() AS 'UTC Now'
UTC Now |
---|
2023-12-21 22:23:45.0645960 |
Syntax of the GETUTCDATE function.
GETUTCDATE()
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'
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.