F_INCDATE

<< F_ADDSECOND | IBExpert UDF Functions | F_INCDATETIME >>

F_INCDATE

 
  • input/output-compatibility to rFunc (INCDATE)
  • Compatible with UTF-8
  • Input TIMESTAMP date optionally time, INTEGER days to add, INTEGER month to add, INTEGER years to add
  • Output TIMESTAMP Adds to parameter 1 days, month and years.

If parameters are negative they will be subtracted.

Example

 select cast('02.11.2019 15:03:05' as timestamp) as ISCORRECT, F_INCDATE('01.10.2018 15:03:05', 1, 1, 1)
 from RDB$DATABASE 
 union
 select cast('31.08.2017 15:03:05' as timestamp) as ISCORRECT, F_INCDATE('01.10.2018 15:03:05', -1, -1, -1)
 from RDB$DATABASE
 union
 select null as ISCORRECT, F_INCDATE(null, null, null, null)
 from RDB$DATABASE;

Expected results:

                 ISCORRECT
 ========================= =========================
                    <null>                    <null>
 2017-08-31 15:03:05.0000  2017-08-31 15:03:05.0000
 2019-11-02 15:03:05.0000  2019-11-02 15:03:05.0000

back to top of page
<< F_ADDSECOND | IBExpert UDF Functions | F_INCDATETIME >>