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!

Restrict "date" format

918464Mar 14 2012 — edited Mar 15 2012

Can I restrict database so that application can not enter date data in certain format.
E.g. If I want that date enter should be registered in [year to minute] 'MM-DD-YYYY' hh:mm' only format and not in [year to second format]'MM-DD-YYYY' hh:mm:ss' then how I can do it in Oracle 11g.
Currently I am using oracle sql developer to create data model and then I want to generate DDL from that to generate database. Is there is any facility in Oracle SQL developer to enforce format specification.

thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 12 2012

Added on Mar 14 2012

#11g, #date, #general-database-discussions, #oracle

2 comments

298 views