The last date of the month can be obtained using the LAST_DAY function.
Example 5:
The maximum temperature date data in the WEATHERMNTBL table is converted to a character string
in the "YYYY.MM.DD DY" format. The date type can be converted to the character type using the
CNV_CHAR function. The conversion is performed in the date format.
115