Skip to Main Content
Forums

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!

"Date" Datatype

918464Mar 13 2012 — edited Mar 13 2012
okay, I am migrating out Informix database to oracle 11g
In informix they are using "date" datatype in database side with two format: year to minute: "%Y-%m-%d %H:%M" and year to second: "%Y-%m-%d %H:%M:%S
now in Oracle 11g how should I use these two format in my DDL script. My script just shows Date as datatype but gives no information about format.
NOTE: I am using Oracle SLQ Developer for generating DDL.

Please help !
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 10 2012
Added on Mar 13 2012
#11g, #date, #oracle
2 comments
242 views