Re: cf query - wanting to set nls date

No they dont't. Neither

select * from abc where to_date(mydate)='7/27/2005';

or

select * from abc where mydate=to_date('7/27/2005');

work.

You get an invalid month error.

Mike Received on Tue Jul 26 2005 - 22:15:57 CDT