<< F_FIRSTDAYNEXTQUARTER | IBExpert UDF Functions | F_FIRSTDAYNEXTMONTH >>

F_LASTDAYNEXTQUARTER

• function from adhoc
• Compatible with UTF-8
• Input TIMESTAMP date optionally time
• Output TIMESTAMP date of last day of next quarter as date with time 00:00:00

Example

 SELECT '31.12.2018' AS ISCORRECT, F_LASTDAYNEXTQUARTER('01.08.2018 15:00:00') FROM RDB$DATABASE;

Expected results:

 ISCORRECT       F_LASTDAYNEXTQUARTER
 ========== =========================
 31.12.2018 2018-12-31 00:00:00.0000

Example

 SELECT '31.03.2019' AS ISCORRECT, F_LASTDAYNEXTQUARTER('02.11.2018 15:00:00') FROM RDB$DATABASE;

Expected results:

 ISCORRECT       F_LASTDAYNEXTQUARTER
 ========== =========================
 31.03.2019 2019-03-31 00:00:00.0000

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