Entrypoint woyiso compatible with UTF-8
Input TIMESTAMP date optionally time Output CSTRING(6) 4 digits year and 2 digits week of the year as a string
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;