F_INDMINUTESBETWEENTHRIB

<< F_INDMINUTESBETWEENTHR | IBExpert UDF Functions | F_SECONDSBETWEEN >>

F_INDMINUTESBETWEENTHRIB

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

special-version for InterBase (also usable with FireBird)

Example

 select 800 as ISCORRECT, F_INDMINUTESBETWEENTHRIB('08.11.2018 07:55:00', '08.11.2018 16:05:00', '08.11.2018 08:00:00', 1, '08.11.2018 16:00:00', 1)
 from RDB$DATABASE;

Expected results:

    ISCORRECT
 ============ ============
          800          800

back to top of page
<< F_INDMINUTESBETWEENTHR | IBExpert UDF Functions | F_SECONDSBETWEEN >>