Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> query on date
Hi
I have a table with the date_of_death as a column dd-mm-yy. Now I wan to run a select statement from this column, where the clause is on the year,
So
select *
from patient
where (trunc ('date_of_death', 'YY') = '94'
//where YY is year
Is this the corect way to run this query
Thanks everyone Received on Fri Mar 31 2000 - 05:31:44 CST