|
-
 that's probably simply something called "an application bug"
It would be nice if you would tell us how you entered this date, because I'm sure that you didnt do it via sqlplus or anything like that.
Did you by any chance enter that value via OCI?
Did you by any chance use the OCI external datatype DATE?
If so, you should carefully read your Oracle Documentation and you would see that:
"When you enter a date in binary format by using the external datatype DATE, the database does not perform consistency or range checking. All data in this format must be validated before input."
For more details have a look at:
http://otn.oracle.com/docs/products/...yp.htm#1003747
HTH
Mike
Last edited by mike9; 07-07-2003 at 05:51 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote