Re: dates
From: x <thewho_at_telepath.com>
Date: Sat, 05 Jun 1999 06:35:31 GMT
Message-ID: <3758E171.4E2A09BD_at_telepath.com>
Date: Sat, 05 Jun 1999 06:35:31 GMT
Message-ID: <3758E171.4E2A09BD_at_telepath.com>
If your time period crosses year end, then this stmt should work. Why do you want to select all of the columns? What kind of error do you get, as if anyone could figure out the error codes LOL
Silicon Knight wrote:
> 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 Sat Jun 05 1999 - 08:35:31 CEST