Skip to Main Content

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!

Change Date Column in database table format from mm/dd/yyyy to dd/mm/yyyy

Dino2dyNov 6 2012 — edited Nov 6 2012
Hi I use Jdeveloper 11G with an Oracle Database.

My table is empty currently but I am importing some excel columns into it and the dates in them are throwing errors because you have some dates like 14/09/2012 which would mean the month is out of range even though its not.

This seems like a simple thing to do but I was unable to find how online.

Please Help
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 4 2012
Added on Nov 6 2012
3 comments
1,320 views