Dofactory.com
Dofactory.com

SQL SYSDATETIME Function

SYSDATETIME returns the current datetime2(7) on the database server.

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

SYSDATETIME is equivalent to CURRENT_TIMESTAMP and GETDATE.

Example

#

This example returns the current datetime on the database server.

SELECT SYSDATETIME() AS 'Now'
Result:  1 record
Now
2023-12-21 16:23:45.709

Syntax

Syntax of the SYSDATETIME function.

SYSDATETIME()

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



Last updated on Dec 21, 2023