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)
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?