meta data for this page
F_FIRSTDAYLASTMONTH
input/output-compatibility to rFunc (FIRSTDAYMONTH)
Entrypoint firstdaylastmonth compatible with UTF-8
Inputs/Outputs
Input TIMESTAMP date optionally time Output TIMESTAMP date of 1st day of last month as date with time 00:00:00
Syntax
TestSQL SELECT '01.04.2009' AS ISCORRECT, F_FIRSTDAYLASTMONTH('08.05.2009 15:00:00') FROM RDB$DATABASE; SELECT '01.12.2008' AS ISCORRECT, F_FIRSTDAYLASTMONTH('03.01.2009 15:00:00') FROM RDB$DATABASE;