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
2021-12-05 03:52:28.247

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



Guides


vsn 3.1