SQL GETDATE Function

GETDATE returns the current datetime on the database server.

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

GETDATE is equivalent to CURRENT_TIMESTAMP.

Example

#

This example returns the current datetime on the database server.

SELECT GETDATE() AS 'Now'
Result:  1 record
Now
2021-12-05 03:19:10.1878673

Syntax

Syntax of the GETDATE function.

GETDATE()

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