meta data for this page
  •  

F_LASTDAYKW

function from adhoc

Entrypoint lastdaykw compatible with UTF-8

Inputs/Outputs

   Input      TIMESTAMP     date optionally time 
   Output     TIMESTAMP     Date with last day of (ISO)week of the year as date with time 00:00:00

Syntax

   TestSQL
   SELECT '02.01.2005' AS ISCORRECT, F_LASTDAYKW(53, 2004) FROM RDB$DATABASE;
   SELECT '09.01.2005' AS ISCORRECT, F_LASTDAYKW(1, 2005) FROM RDB$DATABASE;
   SELECT '04.05.2008' AS ISCORRECT, F_LASTDAYKW(18, 2008) FROM RDB$DATABASE;
   SELECT '29.03.2009' AS ISCORRECT, F_LASTDAYKW(13, 2009) FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_LASTDAYKW(NULL) FROM RDB$DATABASE;