Re: working with dates in oracle
From: Jim Kennedy <kennedy-down_with_spammers_at_no_spam.comcast.net>
Date: Mon, 28 Jul 2003 03:21:48 GMT
Message-ID: <gF0Va.162220$N7.22334_at_sccrnsc03>
Date: Mon, 28 Jul 2003 03:21:48 GMT
Message-ID: <gF0Va.162220$N7.22334_at_sccrnsc03>
select f1,f2 from tablea where lastdate >=
to_date('01/01/2002','mm/dd/yyyy')
(assuming you mean month then day in your format.)
Jim
"UnixUser" <rafel.coyle_at_pfshouston.com> wrote in message
news:a1c0482e.0307271821.468449c3_at_posting.google.com...
> I need to write a query in oracle 8i that will allow me to select some
> rows of date within a date range. In MSSQL I would do something like
> "select f1,f2 from tablea where lastdate >= '01/01/2002'" . How do I
> accomplish the same type of query in Oracle.
Received on Mon Jul 28 2003 - 05:21:48 CEST