<< F_FIRSTDAYWEEKISO | IBExpert UDF Functions | F_FIRSTDAYWOY >>

F_LASTDAYWEEKISO

• function from adhoc
• Compatible with UTF-8
• Input TIMESTAMP date optionally time
• Output TIMESTAMP Date with last day of (ISO) weekday (Sunday) as date with time 00:00:00

Example

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

Expected results:

 ISCORRECT           F_LASTDAYWEEKISO
 ========== =========================
 06.01.2019 2019-01-06 15:00:00.0000

Example

 SELECT NULL AS ISCORRECT, F_LASTDAYWEEKISO(NULL) FROM RDB$DATABASE

Expected results:

 ISCORRECT         F_LASTDAYWEEKISO
 ========= =========================
 <null>                       <null>

back to top of page
<< F_FIRSTDAYWEEKISO | IBExpert UDF Functions | F_FIRSTDAYWOY >>