meta data for this page
F_FIRSTDAYKW
function from adhoc
Entrypoint firstdaykw compatible with UTF-8
Inputs/Outputs
Input TIMESTAMP date optionally time Output TIMESTAMP Date with 1st day of (ISO)week of the year as date with time 00:00:00
Syntax
TestSQL SELECT '27.12.2004' AS ISCORRECT, F_FIRSTDAYKW(53, 2004) FROM RDB$DATABASE; SELECT '03.01.2005' AS ISCORRECT, F_FIRSTDAYKW(1, 2005) FROM RDB$DATABASE; SELECT '28.04.2008' AS ISCORRECT, F_FIRSTDAYKW(18, 2008) FROM RDB$DATABASE; SELECT '23.03.2009' AS ISCORRECT, F_FIRSTDAYKW(13, 2009) FROM RDB$DATABASE; SELECT NULL AS ISCORRECT, F_FIRSTDAYKW(NULL) FROM RDB$DATABASE;