GETDATE

Applies to

Description

Returns the current database system timestamp as a datetime value without the database time zone offset. ().

GETDATE()

CURRENT_TIMESTAMP( [ <fract_sec_precision> ] )

Code:

IN -> SqlServer_01.sql

SELECT GETDATE() AS DATE;

Result:

DATE                   |
-----------------------+
2022-05-06 09:54:42.757|

Code:

OUT -> SqlServer_01.sql

SELECT CURRENT_TIMESTAMP() :: TIMESTAMP AS DATE;

Result:

DATE                   |
-----------------------+
2022-05-06 08:55:05.422|

No issues were found.

No related EWIs.

Last updated 3 months ago