meta data for this page
  •  

F_WOYISO

function from adhoc

Entrypoint woyiso compatible with UTF-8

Inputs/Outputs

   Input     TIMESTAMP      date optionally time
   Output     CSTRING(6)     4 digits year and 2 digits week of the year as a string

Syntax

   Counts like ISO the year and week of year. If 1st January is in week 52, 53 or 54 of the previous year, the output year is also the previous year.
   SELECT '200453' AS ISCORRECT, F_WOYISO('01.01.2005') FROM RDB$DATABASE;
   SELECT '200539' AS ISCORRECT, F_WOYISO('02.10.2005 14:38:12') FROM RDB$DATABASE;
   SELECT F_WOYISO('22.08.2009 14:38:12'), F_WOY('22.08.2009 14:38:12') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_WOYISO(NULL) FROM RDB$DATABASE;