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!

DATE datatype displays different after upgrade to 9i

552758Feb 25 2008 — edited Feb 26 2008

We have just upgraded a client from 8.0.5 to 9.2.03. Previously they would see the date displayed as 30-JUN-07, now they are seeing it as 2007-06-30 00:00:00. The datatype of the column did not change(stayed DATE), and the nls_date_format is set to the default. The client has a site that uses cold fusion 5. I've looked through the backend code and don't see anywhere the date format would be overwritten. What could be the reason for the difference in date format?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 25 2008

Added on Feb 25 2008

#general-database-discussions

3 comments

362 views