{"id":2105,"date":"2011-01-18T09:34:00","date_gmt":"2011-01-18T08:34:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/generation-de-xml-le-format-des-dates\/"},"modified":"2011-01-18T09:34:00","modified_gmt":"2011-01-18T08:34:00","slug":"generation-de-xml-le-format-des-dates","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/generation-de-xml-le-format-des-dates\/","title":{"rendered":"G\u00e9n\u00e9ration de XML : le format des dates"},"content":{"rendered":"<p>Apr\u00e9s une migration de 10gR2 vers 11gR2, une application utilisant les packages DBMS_XMLQUERY pour g\u00e9n\u00e9rer des documents xml est en erreur. Le format des dates a chang\u00e9, qu&#8217;a fait le DBA ?<\/p>\n<p>Un examen des param\u00e8tres NLS ne r\u00e9v\u00e8le pas de diff\u00e9rences entre les deux environnements, au niveau database. La documentation sur le sujet est identique en version <a href=\"http:\/\/download.oracle.com\/docs\/cd\/E11882_01\/appdev.112\/e16760\/d_xmlque.htm#ARPLS69934\">11.2<\/a> et <a href=\"http:\/\/download.oracle.com\/docs\/cd\/B19306_01\/appdev.102\/b14258\/d_xmlque.htm#i1028915\">10.2,<\/a> comme vous pouvez le constater.<\/p>\n<p>S&#8217;est pos\u00e9 alors \u00e0 moi la question suivante : de quoi d\u00e9pend le r\u00e9sultat ? Y a-t-il une d\u00e9pendance au NLS_DATE_FORMAT de l&#8217;instance ou de la session ?<\/p>\n<p>Pour cela, une fonction de validation fut \u00e9crite :<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">create or replace function xmldate return clob as\nctxhdl dbms_xmlquery.ctxtype;\nbegin\nctxhdl:=dbms_xmlquery.newcontext('select sysdate from dual');\u00a0\nreturn(dbms_xmlquery.getxml(ctxhdl));\nend;\n\/<\/pre>\n<p>Cette fonction fut test\u00e9 avec la commande suivante : select xmldate from dual;<br \/>\nOn constate rapidement que le xml g\u00e9n\u00e9r\u00e9 n&#8217;est pas d\u00e9pendant du NLS_DATE_FORMAT.<\/p>\n<h3>Test 1 :<\/h3>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">alter session set NLS_DATE_FORMAT='DD-MON-RR HH12:MI:SS';select '11.2.0.1',sysdate , xmldate from dual;\n alter session set succeeded.\n \n'11.2.0.1' SYSDATE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 XMLDATE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\n---------- ------------------------- -----------------------------------------------\n11.2.0.1\u00a0\u00a0 02-DEC-10 01:13:00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\n 2010-12-02 13:13:00 \u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<samp><\/samp><\/pre>\n<p><samp>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<\/samp><\/p>\n<h3>Test 2 :<\/h3>\n<h2><\/h2>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">alter session set NLS_DATE_FORMAT='YYYYMMDD HH24:MI:SS';select '11.2.0.1',sysdate , xmldate from dual;\nalter session set succeeded.\n'11.2.0.1' SYSDATE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 XMLDATE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\n---------- ------------------------- --------------------------------------------\n11.2.0.1\u00a0\u00a0 20101202 13:13:44\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2010-12-02 13:13:44 <samp><\/samp><\/pre>\n<p>Si ce n&#8217;est le format de date de la session, serait-ce la version ?<\/p>\n<table style=\"width: 623px;\" border=\"2\" align=\"left\">\n<tbody>\n<tr>\n<td><strong>Version<\/strong><\/td>\n<td><strong>R\u00e9sultat<\/strong><strong>\u00a0<\/strong><strong>\u00a0<\/strong><\/td>\n<\/tr>\n<tr>\n<td>10.2.0.4<\/td>\n<td>12\/2\/2010 13:37<\/td>\n<\/tr>\n<tr>\n<td>11.1.0.7<\/td>\n<td>12\/2\/2010 13:44<\/td>\n<\/tr>\n<tr>\n<td>12.2.0.1<\/td>\n<td>2010-12-02 13:13:00<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>On constate un changement de comportement en version 12.2.0.1. Est-ce un bug ?<br \/>\nLe support Oracle nous a rappel\u00e9 qu&#8217;une fonction existait pour definir le format dont nous avions besoin. \ud83d\ude42<\/p>\n<p>Ajoutez la ligne suivante dans le code de la fonction xmldate et le format sera toujours le m\u00eame.<\/p>\n<p>dbms_xmlquery.setdateformat(ctxhdl, &#8216;MM\/dd\/yyyy HH:mm&#8217;);<\/p>\n<p>Heureusement qu&#8217;il y a des bonnes pratiques&#8230; \ud83d\ude42<br \/>\nBon XML !<\/p>\n","protected":false},"excerpt":{"rendered":"<p><span style=\"font-family: verdana,geneva; font-size: 10pt;\">Apr\u00e9s une migration de 10gR2 vers 11gR2, une application utilisant  les  packages DBMS_XMLQUERY pour g\u00e9n\u00e9rer des documents xml est en erreur. Le format des dates a chang\u00e9 qu&#8217;a fait le DBA ?<\/span><\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[4133],"tags":[40,17,41],"class_list":["post-2105","post","type-post","status-publish","format-standard","category-database","tag-nls_lang","tag-oracle-11g","tag-xml"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.9) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>G\u00e9n\u00e9ration de XML : le format des dates - dbi services Blog<\/title>\n<meta name=\"description\" content=\"Apr\u00e9s une migration de 10gR2 vers 11gR2, une application utilisant les packages DBMS_XMLQUERY pour g\u00e9n\u00e9rer des documents xml est en erreur. Le format des dates a chang\u00e9, qu&#039;a fait le DBA ?\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/generation-de-xml-le-format-des-dates\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"G\u00e9n\u00e9ration de XML : le format des dates\" \/>\n<meta property=\"og:description\" content=\"Apr\u00e9s une migration de 10gR2 vers 11gR2, une application utilisant les packages DBMS_XMLQUERY pour g\u00e9n\u00e9rer des documents xml est en erreur. Le format des dates a chang\u00e9, qu&#039;a fait le DBA ?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/generation-de-xml-le-format-des-dates\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2011-01-18T08:34:00+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/generation-de-xml-le-format-des-dates\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/generation-de-xml-le-format-des-dates\\\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/bf7c7eb0bec165183207237c9d0ee1d5\"},\"headline\":\"G\u00e9n\u00e9ration de XML : le format des dates\",\"datePublished\":\"2011-01-18T08:34:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/generation-de-xml-le-format-des-dates\\\/\"},\"wordCount\":240,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"keywords\":[\"NLS_LANG\",\"Oracle 11g\",\"XML\"],\"articleSection\":[\"Database\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/generation-de-xml-le-format-des-dates\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/generation-de-xml-le-format-des-dates\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/generation-de-xml-le-format-des-dates\\\/\",\"name\":\"G\u00e9n\u00e9ration de XML : le format des dates - dbi services Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2011-01-18T08:34:00+00:00\",\"description\":\"Apr\u00e9s une migration de 10gR2 vers 11gR2, une application utilisant les packages DBMS_XMLQUERY pour g\u00e9n\u00e9rer des documents xml est en erreur. Le format des dates a chang\u00e9, qu'a fait le DBA ?\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/generation-de-xml-le-format-des-dates\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/generation-de-xml-le-format-des-dates\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/generation-de-xml-le-format-des-dates\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"G\u00e9n\u00e9ration de XML : le format des dates\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\",\"name\":\"dbi services\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/bf7c7eb0bec165183207237c9d0ee1d5\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/oracle-square.png\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/oracle-square.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/oracle-square.png\",\"caption\":\"Oracle Team\"},\"description\":\"Posts published under the Oracle Team account are collective contributions by the dbi services Oracle consultants. The practice covers the full Oracle Database lifecycle: architecture, migration and upgrade, high availability with RAC and Data Guard, backup and recovery, performance tuning, and engineered systems such as Oracle Database Appliance and Exadata. The team holds Oracle certifications up to Certified Master level and operates customer platforms under service level agreements.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/oracle-team\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"G\u00e9n\u00e9ration de XML : le format des dates - dbi services Blog","description":"Apr\u00e9s une migration de 10gR2 vers 11gR2, une application utilisant les packages DBMS_XMLQUERY pour g\u00e9n\u00e9rer des documents xml est en erreur. Le format des dates a chang\u00e9, qu'a fait le DBA ?","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/generation-de-xml-le-format-des-dates\/","og_locale":"en_US","og_type":"article","og_title":"G\u00e9n\u00e9ration de XML : le format des dates","og_description":"Apr\u00e9s une migration de 10gR2 vers 11gR2, une application utilisant les packages DBMS_XMLQUERY pour g\u00e9n\u00e9rer des documents xml est en erreur. Le format des dates a chang\u00e9, qu'a fait le DBA ?","og_url":"https:\/\/www.dbi-services.com\/blog\/generation-de-xml-le-format-des-dates\/","og_site_name":"dbi services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2011-01-18T08:34:00+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/generation-de-xml-le-format-des-dates\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/generation-de-xml-le-format-des-dates\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bf7c7eb0bec165183207237c9d0ee1d5"},"headline":"G\u00e9n\u00e9ration de XML : le format des dates","datePublished":"2011-01-18T08:34:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/generation-de-xml-le-format-des-dates\/"},"wordCount":240,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"keywords":["NLS_LANG","Oracle 11g","XML"],"articleSection":["Database"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/generation-de-xml-le-format-des-dates\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/generation-de-xml-le-format-des-dates\/","url":"https:\/\/www.dbi-services.com\/blog\/generation-de-xml-le-format-des-dates\/","name":"G\u00e9n\u00e9ration de XML : le format des dates - dbi services Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2011-01-18T08:34:00+00:00","description":"Apr\u00e9s une migration de 10gR2 vers 11gR2, une application utilisant les packages DBMS_XMLQUERY pour g\u00e9n\u00e9rer des documents xml est en erreur. Le format des dates a chang\u00e9, qu'a fait le DBA ?","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/generation-de-xml-le-format-des-dates\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/generation-de-xml-le-format-des-dates\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/generation-de-xml-le-format-des-dates\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"G\u00e9n\u00e9ration de XML : le format des dates"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dbi-services.com\/#organization","name":"dbi services","url":"https:\/\/www.dbi-services.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bf7c7eb0bec165183207237c9d0ee1d5","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/12\/oracle-square.png","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/12\/oracle-square.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/12\/oracle-square.png","caption":"Oracle Team"},"description":"Posts published under the Oracle Team account are collective contributions by the dbi services Oracle consultants. The practice covers the full Oracle Database lifecycle: architecture, migration and upgrade, high availability with RAC and Data Guard, backup and recovery, performance tuning, and engineered systems such as Oracle Database Appliance and Exadata. The team holds Oracle certifications up to Certified Master level and operates customer platforms under service level agreements.","url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2105","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=2105"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2105\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=2105"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=2105"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=2105"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}