Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> query on date

query on date

From: simon cunningham <cs694_at_gre.ac.uk>
Date: Fri, 31 Mar 2000 12:31:44 +0100
Message-ID: <38E48CA0.990C8BAF@gre.ac.uk>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US