meta data for this page
  •  

F_INCDATETIME

input/output-compatibility to rFunc (INCDATETIME)

Entrypoint incdatetime compatible with UTF-8

Inputs/Outputs

   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.

Syntax

   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;