F_LASTDAYQUARTER

<< F_FIRSTDAYQUARTER | IBExpert UDF Functions | F_FIRSTDAYMONTH >>

F_LASTDAYQUARTER

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

Example

 SELECT '30.09.2018' AS ISCORRECT, F_LASTDAYQUARTER('06.09.2018 15:00:00') FROM RDB$DATABASE;

Expected results:

 ISCORRECT           F_LASTDAYQUARTER
 ========== =========================
 30.09.2018 2018-09-30 00:00:00.0000

Example

 SELECT NULL AS ISCORRECT, F_LASTDAYQUARTER(NULL) FROM RDB$DATABASE;

Expected results:

 ISCORRECT          F_LASTDAYQUARTER
 ========= =========================
 <null>                       <null>

back to top of page
<< F_FIRSTDAYQUARTER | IBExpert UDF Functions | F_FIRSTDAYMONTH >>