I'm using Oracle 8i and I've got a customers relation(table) where I need to calculate the age of the customers. I've got their dates of birth in a field called dob, and I tried using SYSDATE with the following command :

select pid, dob(dob, sysdate)
from customers;

For this, I got the error message :
ERROR at line 1:
ORA-00904: invalid column name

What am I doing wrong? Does anyone know how I can calculate the customers' age using SYSDATE? Can anyone help?

Thanks!

ashazi

select pid, trunc((months_between(sysdate, dob))/12) age
from customers;

Hi Sky,
Thanks! That does help.



ashazi