On Jul 24, 7:16 am, Geoff Muldoon <geoff.muld..._at_trap.gmail.com>
wrote:
> 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
Also note that most data on the end date will be excluded... You may
need to make some adjustment.
Received on Mon Jul 23 2007 - 21:11:19 CDT
