meta data for this page
  •  

F_ADDYEAR

compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUDF

Entrypoint addyear compatible with UTF-8

Inputs/Outputs

   Input      TIMESTAMP     date optionally time
              INTEGER       years to add
   Output     TIMESTAMP     adds years to timestamp

Syntax

   If parameter 2 is negative, years where subtract.
   If the output year is a non-leap year, for input 29th February the output is 1st March.
   TestSQL
   SELECT '01.10.2008 15:03:01' AS ISCORRECT, F_ADDYEAR('01.10.2005 15:03:01', 3) FROM RDB$DATABASE;
   SELECT '01.10.2002 15:03:01' AS ISCORRECT, F_ADDYEAR('01.10.2005 15:03:01', -3) FROM RDB$DATABASE;
   SELECT '29.02.2008 15:03:01' AS ISCORRECT, F_ADDYEAR('29.02.2004 15:03:01', 4) FROM RDB$DATABASE;
   SELECT '01.03.2009 15:03:01' AS ISCORRECT, F_ADDYEAR('29.02.2008 15:03:01', 1) FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_ADDYEAR(NULL, NULL) FROM RDB$DATABASE;