meta data for this page
  •  

F_FIRSTDAYNEXTWEEKISO

function from adhoc

Entrypoint firstdaynextweekiso compatible with UTF-8

Inputs/Outputs

   Input      TIMESTAMP     date optionally time
   Output     TIMESTAMP     date of 1st day of next week (ISO)weekday (Monday) as date with time 00:00:00

Syntax

   TestSQL
   SELECT '11.05.2009' AS ISCORRECT, F_FIRSTDAYNEXTWEEKISO('08.05.2009 15:00:00') FROM RDB$DATABASE;
   SELECT '05.01.2009' AS ISCORRECT, F_FIRSTDAYNEXTWEEKISO('30.12.2008 15:00:00') FROM RDB$DATABASE;