meta data for this page
F_LASTDAYLASTWEEKISO
function from adhoc
Entrypoint lastdaylastweekiso compatible with UTF-8
Inputs/Outputs
Input TIMESTAMP date optionally time Output TIMESTAMP date of last day of last week (ISO)weekday (Sunday) as date with time 00:00:00
Syntax
TestSQL SELECT '03.05.2009' AS ISCORRECT, F_LASTDAYLASTWEEKISO('08.05.2009 15:00:00') FROM RDB$DATABASE; SELECT '28.12.2008' AS ISCORRECT, F_LASTDAYLASTWEEKISO('02.01.2009 15:00:00') FROM RDB$DATABASE;