<< F_LASTDAYNEXTQUARTER | IBExpert UDF Functions | F_LASTDAYNEXTMONTH >>

F_FIRSTDAYNEXTMONTH

• input/output-compatibility to rFunc (FIRSTDAYMONTH)
• 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 '01.01.2019' AS ISCORRECT, F_FIRSTDAYNEXTMONTH('11.12.2018 15:00:00') FROM RDB$DATABASE;

Expected results:

 ISCORRECT        F_FIRSTDAYNEXTMONTH
 ========== =========================
 01.01.2019 2019-01-01 00:00:00.0000

Example

 SELECT '01.03.2019' AS ISCORRECT, F_FIRSTDAYNEXTMONTH('27.02.2018 15:00:00') FROM RDB$DATABASE;

Expected results:

 ISCORRECT        F_FIRSTDAYNEXTMONTH
 ========== =========================
 01.03.2019 2018-03-01 00:00:00.0000

back to top of page
<< F_LASTDAYNEXTQUARTER | IBExpert UDF Functions | F_LASTDAYNEXTMONTH >>