F_AGEINWEEKSTHRESHOLDN

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) weeks between timestamp 1 and timestamp 2

Sunday is 1st day of week. If the two dates are in the same week, the return value is 0.

Example

 select null as ISCORRECT, F_AGEINWEEKSTHRESHOLDN('01.01.2019 15:01:21','15.05.2018 15:01:21', 5, 0, 10, 0) from RDB$DATABASE;

Expected results:

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

Follow IBExpertise on:

edit SideBar

the database experts