Entrypoint dayofyear compatible with UTF-8
Input TIMESTAMP date optionally time Output INTEGER number of days (day number x of the year) up to the selected timestamp
F_DAYOFYEAR: counting starts with 1 F_EXTRACTYEARDAY: counting starts with 0 TestSQL SELECT 235 AS ISCORRECT, F_DAYOFYEAR('22.08.2004') FROM RDB$DATABASE; SELECT NULL AS ISCORRECT, F_DAYOFYEAR(NULL) FROM RDB$DATABASE; SELECT 234 AS ISCORRECT, F_EXTRACTYEARDAY('22.08.2004'), F_DAYOFYEAR('22.08.2004') FROM RDB$DATABASE;