meta data for this page
  •  

F_DAYOFWEEK

compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUD

Entrypoint dayofweek compatible with UTF-8

F_EXTRACTWEEKDAY

input/output-compatibility to rFunc (EXTRACTWEEKDAY)

Entrypoint r_weekday compatible with UTF-8

F_DOW

input/output-compatibility to rFunc (DOW)

Entrypoint r_dow compatible with UTF-8

Inputs/Outputs

   Input      TIMESTAMP        date optionally time 
   Output     INTEGER          day of the week as an integer

Syntax

   F_DAYOFWEEK: Sunday = 1, Monday = 2, Thuesday = 3, Wednesday = 4, Thursday = 5, Friday = 6, Saturday = 7
   F_EXTRACTWEEKDAY: Sunday = 0, Monday = 1, Thuesday = 2, Wednesday = 3, Thursday = 4, Friday = 5, Saturday = 6
   F_DOW: Sunday = 7, Monday = 1, Thuesday = 2, Wednesday = 3, Thursday = 4, Friday = 5, Saturday = 6
   TestSQL
   SELECT 1 AS ISCORRECT, F_DAYOFWEEK('22.08.2004') FROM RDB$DATABASE;
   SELECT NULL  AS ISCORRECT, F_DAYOFWEEK(NULL) FROM RDB$DATABASE;
   SELECT 0 AS ISCORRECT, F_EXTRACTWEEKDAY('22.08.2004'), F_DAYOFWEEK('22.08.2004') FROM RDB$DATABASE;
   SELECT 7 AS ISCORRECT, F_DOW('22.08.2004') FROM RDB$DATABASE;