Re: cf query - wanting to set nls date

"mike" <hillmw_at_charter.net> wrote in message news:1122434157.087846.311050_at_f14g2000cwb.googlegroups.com...
> 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
>

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

Is the correct syntax.
Jim Received on Tue Jul 26 2005 - 23:17:47 CDT