<< F_FIRSTDAYWEEK | IBExpert UDF Functions | F_FIRSTDAYWEEKISO >>

F_LASTDAYWEEK

• function from adhoc
• Compatible with UTF-8
• Input TIMESTAMP date optionally time
• Output TIMESTAMP Date with lastday of (US)weekday (Saturday) as date with time 00:00:00

Example

 SELECT '29.12.2018' AS ISCORRECT, F_LASTDAYWEEK('26.12.2018 15:00:00') FROM RDB$DATABASE;

Expected results:

 ISCORRECT              F_LASTDAYWEEK
 ========== =========================
 29.12.2018 2018-12-29 00:00:00.0000

Example

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

Expected results:

 ISCORRECT             F_LASTDAYWEEK
 ========= =========================
 <null>                       <null>

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