F_AGEINDAYSTHRESHOLDN

function from adhoc
Compatible with UTF-8
Input TIMESTAMP (older) date optionally time 1, TIMESTAMP (newer) date optionally time 2, INTEGER min. value, INTEGER min. value is used (0 = no, 1 = yes), INTEGER max. value, INTEGER max. value is used (0 = no, 1 = yes)
Output INTEGER difference in (integer) days between timestamp 1 and timestamp 2

Example

 select null as ISCORRECT, F_AGEINDAYSTHRESHOLDN('01.10.2018 15:01:03', '15.09.2018 15:01:03', 15, 0, -20, 1)
 from RDB$DATABASE;

Expected results:

    ISCORRECT
 ============ ============
       <null>       <null>

Follow IBExpertise on:

edit SideBar

the database experts