F_AGEINHOURS

<< F_AGEINWORKINGDAYS | IBExpert UDF Functions | F_AGEINHOURSN >>

F_AGEINHOURS

 

substitutable with DATEDIFF

  • function from adhoc
  • Compatible with UTF-8
  • Input TIMESTAMP (older) date optionally time 1, TIMESTAMP (newer) date optionally time 2
  • Output INTEGER difference in (integer) hours between timestamp 1 and timestamp 2

if you want a negative number if the first date is newer than the second date

Example

 SELECT 3 AS ISCORRECT, F_AGEINHOURS('01.10.2018 15:01:03','01.10.2018 18:01:03') FROM RDB$DATABASE;

Expected results:

    ISCORRECT F_AGEINHOURS
 ============ ============
            3            3

back to top of page
<< F_AGEINWORKINGDAYS | IBExpert UDF Functions | F_AGEINHOURSN >>