meta data for this page
F_ADDWEEK
function from adhoc
Entrypoint addweek compatible with UTF-8
Inputs/Outputs
Input TIMESTAMP date optionally time INTEGER weeks to add Output TIMESTAMP adds weeks to timestamp
Syntax
If parameter 2 is negative, weeks where subtract. TestSQL SELECT '22.10.2005 15:03:01' AS ISCORRECT, F_ADDWEEK('01.10.2005 15:03:01', 3) FROM RDB$DATABASE; SELECT '10.09.2005 15:03:01' AS ISCORRECT, F_ADDWEEK('01.10.2005 15:03:01', -3) FROM RDB$DATABASE; SELECT NULL AS ISCORRECT, F_ADDWEEK(NULL, NULL) FROM RDB$DATABASE;