Applies to
Description
Returns the current database system timestamp as a datetime value without the database time zone offset. ().
Sample Source Pattern
Syntax
CURRENT_TIMESTAMP( [ <fract_sec_precision> ] )
Examples
Code:
SELECT GETDATE() AS DATE;
Result:
DATE |
-----------------------+
2022-05-06 09:54:42.757|
Code:
SELECT CURRENT_TIMESTAMP() :: TIMESTAMP AS DATE;
Result:
DATE |
-----------------------+
2022-05-06 08:55:05.422|
Known Issues
No issues were found.
No related EWIs.
