<< F_LASTDAY | IBExpert UDF Functions | F_LASTDAYQUARTER >>

F_FIRSTDAYQUARTER

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

Example

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

Expected results:

 ISCORRECT          F_FIRSTDAYQUARTER
 ========== =========================
 01.07.2018 2018-07-01 00:00:00.0000

Example

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

Expected results:

 ISCORRECT         F_FIRSTDAYQUARTER
 ========= =========================
 <null>                       <null>

back to top of page
<< F_LASTDAY | IBExpert UDF Functions | F_LASTDAYQUARTER >>