meta data for this page
  •  

F_LASTDAYWEEKISO

function from adhoc

Entrypoint lastdayweekiso compatible with UTF-8

Inputs/Outputs

   Input      TIMESTAMP     date optionally time 
   Output     TIMESTAMP     Date with last day of (ISO)weekday (Sunday) as date with time 00:00:00

Syntax

   TestSQL
   SELECT '28.12.2008' AS ISCORRECT, F_LASTDAYWEEKISO('26.12.2008 15:00:00') FROM RDB$DATABASE;
   SELECT '04.01.2009' AS ISCORRECT, F_LASTDAYWEEKISO('29.12.2008 15:00:00') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_LASTDAYWEEKISO(NULL) FROM RDB$DATABASE;