Re: cf query - wanting to set nls date

From: Geoff Muldoon <geoff.muldoon_at_trap.gmail.com>
Date: Wed, 27 Jul 2005 13:43:46 +1000
Message-ID: <MPG.1d51adffb4c555339896b8@news.readfreenews.net>

hillmw_at_charter.net says...
> No they dont't. Neither
>
> select * from abc where to_date(mydate)='7/27/2005';

to_char rather than to_date will work on the above.

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

to_date will definitely work on the above.

> work.
>
> You get an invalid month error.

Because you haven't added the optional parameter for the format mask and is it using the default format.

Geoff M Received on Tue Jul 26 2005 - 22:43:46 CDT