dates

From: Silicon Knight <SiliconKnight_at_hotmail.com>
Date: Wed, 2 Jun 1999 15:16:33 -0400
Message-ID: <Kof53.11$1r3.431_at_otma3.state.de.us>



[Quoted] I am trying to do a select on tables based on dates and I can't get it to work.

ex.

[Quoted] [Quoted] 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 Wed Jun 02 1999 - 21:16:33 CEST

Original text of this message