meta data for this page
  •  

F_AGEINWORKINGDAYS

function from adhoc

Entrypoint ageinworkingdays compatible with UTF-8

Inputs/Outputs

   Input      TIMESTAMP          (older) date optionally time 1
              TIMESTAMP          (newer) date optionally time 2
              INTEGER            weekday don't calculate
   Output     INTEGER            difference in (integer) days between timestamp 1 and timestamp 2 less of 
                                 weekday/s from param 3

Syntax

   weekday: Monday = 1, Tuesday = 2, Wednesday = 3, Thursday = 4, Friday = 5, Saturday = 6, Sunday = 7
   If 1st date is newer than 2nd date, the result is negative.
   Any order of indexes for weekdays. Only allowed indexes are calculated.
   Test SQL
   SELECT 4 AS ISCORRECT, F_AGEINWORKINGDAYS('12.12.2008', '17.12.2008', 7) FROM RDB$DATABASE;
   SELECT 3 AS ISCORRECT, F_AGEINWORKINGDAYS('12.12.2008', '17.12.2008', 67) FROM RDB$DATABASE;
   SELECT -3 AS ISCORRECT, F_AGEINWORKINGDAYS('17.12.2008', '12.12.2008', 67) FROM RDB$DATABASE;
   SELECT 3 AS ISCORRECT, F_AGEINWORKINGDAYS('12.12.2008', '17.12.2008', 467) FROM RDB$DATABASE;
   SELECT 5 AS ISCORRECT, F_AGEINWORKINGDAYS('12.12.2008', '17.12.2008', 9) FROM RDB$DATABASE;
   SELECT 5 AS ISCORRECT, F_AGEINWORKINGDAYS('12.12.2008', '17.12.2008', 890) FROM RDB$DATABASE;
   SELECT 0 AS ISCORRECT, F_AGEINWORKINGDAYS('09.01.2009', '09.01.2009', 67) FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_AGEINWORKINGDAYS(NULL, NULL, NULL) FROM RDB$DATABASE;