| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: default date formats for varchar2?
A copy of this was sent to SHL9_at_cornell.edu (Steve)
(if that email address didn't require changing)
On 3 Jan 1999 14:54:48 GMT, you wrote:
>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
Please give an example -- it doesn't work as you describe. It must be in the way you are using them. A short example will help us to solve the problem.....
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Sun Jan 03 1999 - 09:16:40 CST
 |
 |