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!

XML date format

pkchanMar 2 2009 — edited Mar 2 2009

I have existing packages that output XML on date columns without specifying the date format, by default it was using DD-MON-YYYY. When we migrated to 10g, the format is changed to YYYY-MM-DD. Is there a way to correct this without changing the stored procedures to use the TO_CHAR function and without changing the system/session NLS_DATE_FORMAT. Is there a way to specify the date format when we use these XML functions? Same question on using DBMS_XMLGEN.

thanks
pkchan

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 30 2009

Added on Mar 2 2009

4 comments

439 views