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