<< F_FIRSTDAYNEXTMONTH | IBExpert UDF Functions | U_CYRILLIC_LATIN? >>

F_LASTDAYNEXTMONTH

• input/output-compatibility to rFunc (LASTDAYMONTH)
• Compatible with UTF-8
• Input TIMESTAMP date optionally time
• Output TIMESTAMP date of 1st day of next month as date with time 00:00:00

Example

 SELECT '31.01.2019' AS ISCORRECT, F_LASTDAYNEXTMONTH('11.12.2018 15:00:00') FROM RDB$DATABASE;

Expected results:

 ISCORRECT         F_LASTDAYNEXTMONTH
 ========== =========================
 31.01.2019 2019-01-31 00:00:00.0000

Example

 SELECT '28.02.2019' AS ISCORRECT, F_LASTDAYNEXTMONTH('27.01.2019 15:00:00') FROM RDB$DATABASE;

Expected results:

 ISCORRECT         F_LASTDAYNEXTMONTH
 ========== =========================
 28.02.2019 2019-02-28 00:00:00.0000

back to top of page
<< F_FIRSTDAYNEXTMONTH | IBExpert UDF Functions | U_CYRILLIC_LATIN? >>