Re: dates

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 - 01:35:31 CDT