meta data for this page
  •  

F_WOY

(don't use)

compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP

Entrypoint woy compatible with UTF-8

Inputs/Outputs

   Input      TIMESTAMP      date optionally time 
   Output     CSTRING(6)     year and week as a string

Syntax

   Counts like Gregory Deatz the year and week of year (week starting with Sunday - see above).
   TestSQL
   SELECT '200434' AS ISCORRECT, F_WOY('22.08.2004 14:38:12') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_WOY(NULL) FROM RDB$DATABASE;