Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Wrong Dates are Written to Oracle Datebase

Status
Not open for further replies.

ProgVictim

Programmer
Sep 9, 2004
1
CA
I have an Oracle Database where the data entry and retrieval to and from the database is done through Visual Manufacturing application. Two weeks ago I found that certain dates such as Transaction_Date, Create_Date, in a certain tables are saved incorrectly to the database. For example if the Transaction_Date should be 01-MAR-2004, it is saved as 11-MAY-2009!

I tried to find a pattern in the wrong dates but it does not seem to be any consistency. The dates are randomly changed.

The date fields are of DATE data types..

Can anyone help on that?

Thanks very much

David Shenoda
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top