DayOfMonth
Summary
The DayOfMonth function returns the numeric day of the month for a specified date.
Syntax
DayOfMonth(<date|date_time|instant|offset_date_time|zoned_date_time>) |
Return Type
Integer
Details
Values range from 1-31.
Examples
eval DayOfMonth(ToDate(‘2042-04-01’));
select date1, DayOfMonth(date1), DayOfMonth(date_time1), DayOfMonth(offset_date_time1), DayOfMonth(zoned_date_time1) from AllTypes();
