F_AGEINYEARSN

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) years 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_AGEINYEARSN('12.12.2018', '12.12.2013') FROM RDB$DATABASE;

Expected results:

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

Follow IBExpertise on:

edit SideBar

the database experts