meta data for this page
F_FIRSTDAYWEEKISO
function from adhoc
Entrypoint firstdayweekiso compatible with UTF-8
Inputs/Outputs
Input TIMESTAMP date optionally time Output TIMESTAMP Date with 1st day of (ISO)weekday (Monday) as date with time 00:00:00
Syntax
TestSQL SELECT '22.12.2008' AS ISCORRECT, F_FIRSTDAYWEEKISO('26.12.2008 15:00:00') FROM RDB$DATABASE; SELECT '29.12.2008' AS ISCORRECT, F_FIRSTDAYWEEKISO('03.01.2009 15:00:00') FROM RDB$DATABASE; SELECT NULL AS ISCORRECT, F_FIRSTDAYWEEKISO(NULL) FROM RDB$DATABASE;