Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Date Corruption problem
In article <382A820F.18A96296_at_synergy-infotech.com>, Anurag Minocha
<anurag_at_synergy-infotech.com> writes
>Hi,
>I am facing a queer problem. My Dates are getting corrupted and i dont
>know how. The year is becomming 1910 from 1999 and sometimes 0000 also .
>Months are becoming more than 12 etc.
> I am sending
>the dump file which contains the tables with corrupted dates. You can
>import them with full=y.
>There are four tables in all. I am sending the script also which will
>select the invalid dates. It is called InvalidDates.sql. It will spool
>the results into dates.log. Please go through the results and suggest
>some remedy.
>
>
>Thanks
>Anurag
>
>Please reply at
>anurag_at_synergy-infotech.com
>
>[ A MIME application / x-unknown-content-type-sql_auto_file part was included
>here. ]
>
>
>[ A MIME application / x-zip-compressed part was included here. ]
>
Anurag,
You appear to have accidentally sent 125K of binary files to this newsgroup. From the tone of accompanying text, you seem to believe that you have sent this to your support team?
Andy
--
Andy Hardy. PGP key available on request