Re: Date Corruption problem

A copy of this was sent to Anurag Minocha <anurag_at_synergy-infotech.com> (if that email address didn't require changing) On Thu, 11 Nov 1999 14:15:03 +0530, you wrote:

>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.
>

what is the mechanism by which these dates get inserted/updated. show us that code (a very very very small snippet if you please -- not nearly as much as your original post)

>
>Thanks
>Anurag
>
>Please reply at
>anurag_at_synergy-infotech.com

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Nov 11 1999 - 08:33:58 CST