F_AGEINDAYSN

<< F_AGEINDAYS | IBExpert UDF Functions | F_AGEINWORKINGDAYS >>

F_AGEINDAYSN

 

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

if you want <null> if the first date is newer than the second date

Example

 SELECT NULL AS ISCORRECT, F_AGEINDAYSN('01.10.2018 15:01:03','11.09.2018 15:04:03') FROM RDB$DATABASE;

Expected results:

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

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