meta data for this page
F_LASTDAYMONTH
input/output-compatibility to rFunc (LASTDAYMONTH)
Entrypoint lastdaymonth compatible with UTF-8
Inputs/Outputs
Input TIMESTAMP date optionally time Output TIMESTAMP Date with last of the month as date with time 00:00:00
Syntax
TestSQL SELECT '31.01.2007 00:00:00' AS ISCORRECT, F_LASTDAYMONTH('03.01.2007 15:00:00') FROM RDB$DATABASE; SELECT NULL AS ISCORRECT, F_LASTDAYMONTH(NULL) FROM RDB$DATABASE;