SQL & PL/SQL

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!

Null time in the date column

18876Mar 18 2002

I have a datetime attribute wherein I have to specify the date as well as time (if available). But if I specify date without any value for time, I am getting 00/00/00 (HH/MI/SS) which is wrong for my case. I should get a 'null' time instead of 00/00/00.

Any workaround???
Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 21 2002

Added on Mar 18 2002

3 comments

479 views