Re: dates

From: Jefferson Humber <matrix01_at_globalnet.co.uk>
Date: Fri, 4 Jun 1999 19:03:40 +0100
Message-ID: <7j94e1$eb9$2@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 - 13:03:40 CDT