Description
This function returns an integer that represents the day (day of the month) of the specified date. ().
Sample Source Pattern
Syntax
DAY( <date_or_timestamp_expr> )
Examples
Code:
SELECT DAY('10-10-2022') AS DAY
Result:
Code:
SELECT DAY('10-10-2022' :: TIMESTAMP) AS DAY;
Result: