<< F_INCDATE | IBExpert UDF Functions | F_ADDPERIOD >>

F_INCDATETIME

• input/output-compatibility to rFunc (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.

Example

 select cast('02.11.2018 16:04:06' as timestamp) as ISCORRECT, F_INCDATETIME('01.10.2017 15:03:05', 1, 1, 1, 1, 1, 1)
 from RDB$DATABASE
 union
 select cast('02.11.2018 14:02:04' as timestamp) as ISCORRECT,
       F_INCDATETIME('01.10.2017 15:03:05', 1, 1, 1, -1, -1, -1)
 from RDB$DATABASE
 union
 select null as ISCORRECT, F_INCDATETIME(null, null, null, null, null, null, null)
 from RDB$DATABASE;

Expected results:

                 ISCORRECT
 ========================= =========================
                    <null>                    <null>
 2018-11-02 14:02:04.0000  2018-11-02 14:02:04.0000
 2018-11-02 16:04:06.0000  2018-11-02 16:04:06.0000

back to top of page
<< F_INCDATE | IBExpert UDF Functions | F_ADDPERIOD >>