hi i want to know how to count years from dates...
so todays_date minus 14-Feb-1999 = 5 years....
right now im using
SELECT P.LAST_NAME as "Last Name",
((SYSDATE - P.DATE_LAST_UPDATED)/365) as "years"
FROM PATIENT P;
is there any way thats simpler than divide by 365?
thank you so much