Re: Simple Query Question

From: Geoff Muldoon <geoff.muldoon_at_trap.gmail.com>
Date: Tue, 24 Jul 2007 09:16:57 +1000
Message-ID: <MPG.210fe1f5e0877ba198997c@news.readfreenews.net>

Smitty says...

> > > > Hi, if you're up to using sqlplus, try something like the following.
> >
> > > > select something
> > > > from somewhere
> > > > where yourDateColumn between to_date('&d1','dd-mon-yyyy') and
> > > > to_date('&d2','dd-mon-yyyy')
> >
> > > > Change the date mask to whatever you require.

        ^^^^^^^^^^^^^^^^^^^^

> > Is it something like 07-23-2007
>
> That's exactly the date format I have been entering.

Read the advice.

Change your date mask: to_date('&d1','mm-dd-yyyy')

Or input in the format: 23-JUL-2007

GM Received on Mon Jul 23 2007 - 18:16:57 CDT