meta data for this page
  •  

F_INCDATE

input/output-compatibility to rFunc (INCDATE)

Entrypoint incdate compatible with UTF-8

Inputs/Outputs

   Input     TIMESTAMP     date optionally time
             INTEGER       days to add
             INTEGER       month to add
             INTEGER       years to add
   Output    TIMESTAMP     Adds to parameter 1 day, month, and years.

Syntax

   If parameters are negative they will be subtracted.
   TestSQL
   SELECT '02.11.2006 15:03:05' AS ISCORRECT, F_INCDATE('01.10.2005 15:03:05', 1, 1, 1) FROM RDB$DATABASE;
   SELECT '31.08.2004 15:03:05' AS ISCORRECT, F_INCDATE('01.10.2005 15:03:05', -1, -1, -1) FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_INCDATE(NULL, NULL, NULL, NULL) FROM RDB$DATABASE;