Re: default date formats for varchar2?

I find this hard to believe. What is the source of the data that is inserted into the column?
I would look hard into the application code (forms, reports,sql*loader??) to ensure that an erroneous date conversion has not been made, e.g. a "to_date" function applied to the wrong field ...

Regards

Glenn Baron

Steve <SHL9_at_cornell.edu> wrote in article <76o0bo$eat_at_newsstand.cit.cornell.edu>...
> My problem is that I have a varchar2[10] that I have loaded with what
should be
> 5 digit phone numbers [5-1934] but the problem is that Oracle seems to
think
> that these are dates and forces a format of May-1934 (or whatever) on
them. Any
> ideas on how I can turn off or override this default formatting? Note,
this is
> not a date field, it is a varchar2.
> Thanks for any help - Steve ; SHL9_at_cornell.edu
>
>
Received on Mon Jan 04 1999 - 14:40:44 CST