Re: range partition on char column

From: mario <xnazsco_at_tiscali.it>
Date: Mon, 10 Jul 2006 14:38:26 +0200
Message-ID: <pan.2006.07.10.12.38.25.905571@tiscali.it>

Il Sat, 08 Jul 2006 11:26:57 +0000, ha scritto:

> On Fri, 07 Jul 2006 19:50:40 GMT, j.w.vandijk.removethis_at_hetnet.nl
> (Jaap W. van Dijk) wrote:
> p.
>

[CUT]
> Hi Jaap,
>
> You are quite right.
>
> Mario : You can do as Jaap says or consider converting CDATE from CHAR
> type to the more appropriate DATE type with
>
> alter session set nls_date_format = 'yyyy-mm-dd';
>

[CUT]
> - Kenneth Koenraadt

Hi,
I've tried both the way suggested by
Jaap and by Kenneth. They works fine.
Today I've learned a new detail about oracle :)

thank's to people answered my post.

best regards
M. Received on Mon Jul 10 2006 - 07:38:26 CDT