Path: news.easynews.com!easynews!feed2.onemain.com!feed1.onemain.com!feed1.newsreader.com!netnews.com!xfer02.netnews.com!newsfeed1.cidera.com!Cidera!portc01.blue.aol.com!audrey04.news.aol.com!not-for-mail
Lines: 4
X-Admin: news@aol.com
From: noodles@aol.com (Noodles)
Newsgroups: comp.databases.oracle.tools
Date: 01 Jan 2002 22:11:00 GMT
References: <m0pu4tls1p.fsf@franz.athome>
Organization: AOL http://www.aol.com
Subject: Re: [REPOST] The "TO_DATE" Function Question
Message-ID: <20020101171100.19179.00000511@mb-cp.aol.com>
Xref: easynews comp.databases.oracle.tools:47428
X-Received-Date: Tue, 01 Jan 2002 21:25:16 MST (news.easynews.com)

Have you tried changing your format mask to 'DD-MON-YY'   so that the string
formats match exactly?

Cliff