Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: dates
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