Re: dates
From: Jefferson Humber <matrix01_at_globalnet.co.uk>
Date: Fri, 4 Jun 1999 19:03:40 +0100
Message-ID: <7j94e1$eb9$2_at_gxsn.com>
Date: Fri, 4 Jun 1999 19:03:40 +0100
Message-ID: <7j94e1$eb9$2_at_gxsn.com>
[Quoted] This SQL seems to work fine under OpenVMS running Oracle Rdb 7.01. What are [Quoted] 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 - 20:03:40 CEST