Re: cf query - wanting to set nls date

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. Received on Tue Jul 26 2005 - 21:16:26 CDT