<< F_FIRSTDAYWOY | IBExpert UDF Functions | F_FIRSTDAYKW >>

F_LASTDAYWOY

• function from adhoc
• Compatible with UTF-8
• Input INTEGER week number, INTEGER year
• Output TIMESTAMP Date with last day of (US)week of the year as date with time 00:00:00

Example

 SELECT '05.01.2019' AS ISCORRECT, F_LASTDAYWOY(1, 2019) FROM RDB$DATABASE;

Expected results:

 ISCORRECT               F_LASTDAYWOY
 ========== =========================
 05.01.2019 2019-01-05 00:00:00.0000

Example

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

Expected results:

 ISCORRECT              F_LASTDAYWOY
 ========= =========================
 <null>                       <null>

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