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!

Register Log in
  • Congratulations TouchToneTommy 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

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.

Similar threads

Sandy Sal
  • Locked
  • Question
Oracle financial error app 01125
Replies
0
Views
244
Sandy Sal
Sandy Sal
imghani123
  • Locked
  • Question
I am new to Tableau having backgrou
Replies
0
Views
226
imghani123
imghani123
tekpr00
  • Locked
  • Question
Oracle Enterprise Manager Cloud Control 12c
Replies
0
Views
241
tekpr00
tekpr00
baran121
  • Locked
  • Question
connection to oracle database
Replies
0
Views
233
baran121
baran121
go22blue
  • Locked
  • Question
Oracle ERP Project BOM
Replies
0
Views
242
go22blue
go22blue

Part and Inventory Search

Sponsor

Back
Top