Re: oracle

From: Kenneth Koenraadt <plovmand_at_hotmail.com>
Date: Sat, 19 May 2001 18:03:13 GMT
Message-ID: <3b06b500.668779@news.mobilixnet.dk>

Make it :

to_date('$&$/$&$/$&$','MM/DD/YYYY') AND
(to_date('$&$/$&$/$&$','MM/DD/YYYY') + 1);

MM (Not "Mon") = Month

Regards,

Kenneth Koenraadt
Systems Consultant
plovmand@<no-spam>hotmail.com

On 18 May 2001 14:07:27 -0700, aghosal_at_qwest.com (Aloy Kumar Ghosal) wrote:

>please help me in finding out what is the problem
>with the following piece of code:
>
>SELECT..........FROM...........WHERE....... and date BETWEEN
>to_date('$&$/$&$/$&$','Mon/DD/YYYY') AND
> (to_date('$&$/$&$/$&$','Mon/DD/YYYY') + 1);
Received on Sat May 19 2001 - 13:03:13 CDT