975685 wrote:I don't believe you.
Somehow the following DATE field data (this is from a SQL*Plus query that did not manipulate the date just did a straight-up query, so the format is our default) is in our database:
How did it get in there with hours like that? I have tried a few different insert statements and I can't find a way to get a date like that into the database. There is no date arithmetic done on it on this server, it's probably coming from another machine/server just like that (still trying to track that down). Does SQL*Loader or some other method bypass Oracle's date validation or is there something else I'm missing?
It's an Oracle DB (10.2.0.1.0) and it is just a standard DATE field.
SELECT dateColumn, DUMP(dateColumn) from myTable;
22-OCT-12 27:22:30It looks like the value is corrupted. It may be corrupted in 2 places - in table and in index(exes) that have CURE_DT.
22-OCT-12 15:22:30 PM