Description
This function returns the last day of the month containing a specified date, with an optional 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|