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:

*2012/10/22 27:22:30*

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?

975685 wrote:
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:

*2012/10/22 27:22:30*

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?

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

2012/10/22 27:22:30

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.
>
Well I've never known the DUMP function to lie about what it finds so show us that result