SYSDATETIMEOFFSET returns the current datetime with timezone on the database server.
This function can be used as default value for DATETIMEOFFSET and DATETIME columns.
The example returns the current datetime with timezone offset on the database server.
SELECT SYSDATETIMEOFFSET() AS 'Now'
| Now |
|---|
| 2023-12-21 16:23:45.8385649 -06:00 |
Syntax of the SYSDATETIMEOFFSET function.
SYSDATETIMEOFFSET()
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.
