"mike" <hillmw_at_charter.net> wrote in message
news:1122430586.856120.254410_at_o13g2000cwo.googlegroups.com...
> well i didn't want to alter the sql string
>
> select * from abc where mydate='7/27/2005';
>
> additionally to_date() only works in select clause not the where clause
> of the statement.
>
> The other option I have is to use javascript to convert the date to
> 27-Jul-2005 and then use in my sql.
>
> Any other thoughts appreciated.
>
Yes, it does work in the where clause.
Jim
Received on Tue Jul 26 2005 - 21:26:35 CDT
