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 -> Re: dates

Re: dates

From: Glenn Baron <gbaron_at_dial.pipex.com>
Date: 4 Jun 1999 22:30:18 GMT
Message-ID: <01beaeda$27e6e720$be83bc3e@default>


In what way doesn't it work ?? Returns no rows or fewer than expected or what?

cheers

Glenn Baron

Jefferson Humber <matrix01_at_globalnet.co.uk> wrote in article <7j94e1$eb9$2_at_gxsn.com>...
> This SQL seems to work fine under OpenVMS running Oracle Rdb 7.01. What
are
> you trying to execute it on ?
>
> Jeff
>
>
> Silicon Knight <SiliconKnight_at_hotmail.com> wrote in message
> news:Kof53.11$1r3.431_at_otma3.state.de.us...
> > I am trying to do a select on tables based on dates and I can't get it
to
> > work.
> >
> > ex.
> >
> > select * from table where initial_date < '01-Jan-99' and final_date >
> > '01-Jan-99';
> >
> > any idea why this doesn't work?
> >
> > Thanks in advance,
> >
> > Tim
> >
> >
>
>
>
Received on Fri Jun 04 1999 - 17:30:18 CDT

Original text of this message

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