<< F_LASTDAYKW | IBExpert UDF Functions | F_LASTDAYLASTQUARTER >>

F_FIRSTDAYLASTQUARTER

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

Example

 SELECT '01.10.2018' AS ISCORRECT, F_FIRSTDAYLASTQUARTER('27.02.2019 15:00:00') FROM RDB$DATABASE;

Expected results:

 ISCORRECT      F_FIRSTDAYLASTQUARTER
 ========== =========================
 01.10.2018 2018-10-01 00:00:00.0000

Example

 SELECT '01.01.2018' AS ISCORRECT, F_FIRSTDAYLASTQUARTER('27.05.2018 15:00:00') FROM RDB$DATABASE;

Expected results:

 ISCORRECT      F_FIRSTDAYLASTQUARTER
 ========== =========================
 01.01.2018 2018-01-01 00:00:00.0000

back to top of page
<< F_LASTDAYKW | IBExpert UDF Functions | F_LASTDAYLASTQUARTER >>