Re: query on date

> 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'
> file://where YY is year
> Is this the corect way to run this query
>

Do it more simple:

select * from patient where trunc (date_of_death, 'YY') = 94

regards
Nicolas Bronke Received on Fri Mar 31 2000 - 06:55:42 CST