Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Zero DATE

404732Sep 24 2003 — edited Sep 25 2003

Is it allowed to set a DATE field with its date part to zero values (I mean 00/00/00), and its time part to a valid time value ?

I'm using a tool that makes it, thru OCI. But when trying to get data from SQL it fails.

Moreover, is it "officially" forbidden -or allowed- to set a zero-date value in Oracle?

Thank you very much for any help !

Pascal

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 23 2003

Added on Sep 24 2003

#general-database-discussions

6 comments

556 views