Entrypoint incdatetime compatible with UTF-8
Input TIMESTAMP date optionally time INTEGER days to add INTEGER month to add INTEGER years to add INTEGER hours to add INTEGER minutes to add INTEGER seconds to add Output TIMESTAMP Adds to parameter 1 days, month, years, hours, minutes, and seconds.
If parameters are negative they will be subtracted. TestSQL SELECT '02.11.2006 16:04:06' AS ISCORRECT, F_INCDATETIME('01.10.2005 15:03:05', 1, 1, 1, 1, 1, 1) FROM RDB$DATABASE; SELECT '02.11.2006 14:02:04' AS ISCORRECT, F_INCDATETIME('01.10.2005 15:03:05', 1, 1, 1, -1, -1, -1) FROM RDB$DATABASE; SELECT NULL AS ISCORRECT, F_INCDATETIME(NULL, NULL, NULL, NULL, NULL, NULL, NULL) FROM RDB$DATABASE;