Skip to Main Content
Forums

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!

Creating table with date format YYYY-MM-DD

427492Dec 6 2004 — edited Dec 6 2004
Date is stored in the format YYYY-MM-DD HH-MM-SS unless if the time entered is 12:00:00 AM, in which case a select output will be in the format YYYY-MM-DD. Is there a way to create a table having a date column to have a default time of 12:00:00 AM, so that only the date needs to be inserted? Is this possible?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 3 2005
Added on Dec 6 2004
#general-database-discussions
6 comments
5,084 views