Entrypoint year compatible with UTF-8
(don't use)
Entrypoint yearofyear compatible with UTF-8
Input TIMESTAMP date optionally time Output INTEGER year of the timestamp
F_YEAR counts with USA-Norm: week starting with Sunday, week 1 contains 1st January. F_YEAROFYEAR counts wrong (not ISO): week starts with Sunday, week 1 starts with Sunday to Wednesday TestSQL SELECT 2004 AS ISCORRECT, F_YEAR(' 22.08.2004 14:38:12') FROM RDB$DATABASE; SELECT NULL AS ISCORRECT, F_YEAR(NULL) FROM RDB$DATABASE; SELECT 2004 AS ISCORRECT, F_YEAROFYEAR(' 22.08.2004 14:38:12') FROM RDB$DATABASE; SELECT NULL AS ISCORRECT, F_YEAROFYEAR(NULL) FROM RDB$DATABASE;