Re: working with dates in oracle
From: KULJEET <kuljeet_twtpl_at_hotmail.com>
Date: 27 Jul 2003 23:21:10 -0700
Message-ID: <febbed51.0307272221.5887b65e_at_posting.google.com>
Date: 27 Jul 2003 23:21:10 -0700
Message-ID: <febbed51.0307272221.5887b65e_at_posting.google.com>
rafel.coyle_at_pfshouston.com (UnixUser) 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.
try-->
select f1,f2 from tablea where to_char(lastdate,'DD/MM/YYYY') >= '01/01/2002';
Received on Mon Jul 28 2003 - 08:21:10 CEST