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

simpler? sure, several ways

the easiest is

select year(p.date_last_updated) - year(sysdate)

check your database for something like a DATEDIFF function too

While this is syntactically simpler, you can still run into problems if you don't consider whether the SYSDATE day of the year is before/after the day of the p.date_last_updated day of the year.

-PatP