| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: An Oracle Date bug: 00-00-0000 ?
If you mean OCI instead of OIC then with the Oracle Call Interface it is
the application's responsibility to validate dates before entering them.
With any Pro* language like Pro*C and in sqlplus Oracle would validate the
date column value before inserting it to the database. But with OCI Oracle
will accept what you five it.
>>>>>
Luca Minudel <luca.minudel_at_nline.it> wrote in article
A front-end application insert rows in an Oracle Db using OIC interface to
Oracle I guess. I've found a Date value set to 00-00-0000 in a table
column. When I convert Datae to Julian format and then I convert it back
to Date format I get 01-Dic-0001 date value...
I can understand that a front-end application running under Windows95 can be buggy, but qhat's going on with Oracle?
Luca Minudel software designer<<<<< Received on Tue Jul 07 1998 - 08:50:44 CDT
 |
 |