{"id":52,"date":"2013-02-08T11:04:45","date_gmt":"2013-02-08T11:04:45","guid":{"rendered":"http:\/\/www.einaweb.es\/dev\/?p=52"},"modified":"2013-02-08T11:04:45","modified_gmt":"2013-02-08T11:04:45","slug":"problemas-to_charsysdated-misma-sql-rentorna-cosas-diferentes","status":"publish","type":"post","link":"http:\/\/www.einaweb.es\/develop\/problemas-to_charsysdated-misma-sql-rentorna-cosas-diferentes\/","title":{"rendered":"Problemas to_char(sysdate,&#8217;D&#8217;) misma sql rentorna cosas diferentes"},"content":{"rendered":"<p>En Oracle cuando ejecutas la consulta select to_char(sysdate,&#8217;D&#8217;) retorna el dia de la semana en la que esta la feche que le pasas.<\/p>\n<p>El problema viene que depende de la sessi\u00f3n que hayas realizado para la conexion a oracle el valor puede ser uno o otro ya que en estados unidos el primer dia de la semana es el domingo y aqui en espa\u00f1a el primer dia es el lunes.<\/p>\n<p>Aunque al final del to_char le pases el &#8216;NLS_DATE_LANGUAGE=SPANISH&#8217; devolvera lo mismo ya que prevalece las variables de la sesi\u00f3n.<\/p>\n<p>Dichas variables estan en la tabla nls_session_parameters.<\/p>\n<p>La unica solucion es recoger los nombres que eso si que lo devuelve en los distintos idiomas pero tendremos que realizar un trim para realizar la comparaci\u00f3n ya que al final de todo vienen espacios.<\/p>\n<p>&#8216;DILLUNS&#8217; = trim (to_char(SYSDATE,&#8217;DAY&#8217;,&#8217;NLS_DATE_LANGUAGE=catalan&#8217;))<br \/>\n&#8216;DIMARTS&#8217; = trim (to_char(SYSDATE,&#8217;DAY&#8217;,&#8217;NLS_DATE_LANGUAGE=catalan&#8217;))<br \/>\n&#8216;DIMECRES&#8217; = trim (to_char(SYSDATE,&#8217;DAY&#8217;,&#8217;NLS_DATE_LANGUAGE=catalan&#8217;))<br \/>\n&#8216;DIJOUS&#8217; = trim (to_char(SYSDATE,&#8217;DAY&#8217;,&#8217;NLS_DATE_LANGUAGE=catalan&#8217;))<br \/>\n&#8216;DIVENDRES&#8217; = trim (to_char(SYSDATE,&#8217;DAY&#8217;,&#8217;NLS_DATE_LANGUAGE=catalan&#8217;))<br \/>\n&#8216;DISSABTE&#8217; = trim (to_char(SYSDATE,&#8217;DAY&#8217;,&#8217;NLS_DATE_LANGUAGE=catalan&#8217;))<br \/>\n&#8216;DIUMENGE&#8217; = trim (to_char(SYSDATE,&#8217;DAY&#8217;,&#8217;NLS_DATE_LANGUAGE=catalan&#8217;))<\/p>\n","protected":false},"excerpt":{"rendered":"<p>En Oracle cuando ejecutas la consulta select to_char(sysdate,&#8217;D&#8217;) retorna el dia de la semana en la que esta la feche que le pasas. El problema viene que depende de la sessi\u00f3n que hayas realizado para la conexion a oracle el valor puede ser uno o otro ya que en estados unidos el primer dia de [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-52","post","type-post","status-publish","format-standard","hentry","category-oracle"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Problemas to_char(sysdate,&#039;D&#039;) misma sql rentorna cosas diferentes - Blog Desarrollador<\/title>\n<meta name=\"description\" content=\"Problemas to_char(sysdate,&#039;D&#039;) misma sql rentorna cosas diferentes - Blog Desarrollador\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/www.einaweb.es\/develop\/problemas-to_charsysdated-misma-sql-rentorna-cosas-diferentes\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Problemas to_char(sysdate,&#039;D&#039;) misma sql rentorna cosas diferentes - Blog Desarrollador\" \/>\n<meta property=\"og:description\" content=\"Problemas to_char(sysdate,&#039;D&#039;) misma sql rentorna cosas diferentes - Blog Desarrollador\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.einaweb.es\/develop\/problemas-to_charsysdated-misma-sql-rentorna-cosas-diferentes\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog Desarrollador\" \/>\n<meta property=\"article:published_time\" content=\"2013-02-08T11:04:45+00:00\" \/>\n<meta name=\"author\" content=\"Angel Fernandez Gutierrez\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@afernandezg76\" \/>\n<meta name=\"twitter:site\" content=\"@afernandezg76\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Angel Fernandez Gutierrez\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"http:\/\/www.einaweb.es\/develop\/problemas-to_charsysdated-misma-sql-rentorna-cosas-diferentes\/\",\"url\":\"http:\/\/www.einaweb.es\/develop\/problemas-to_charsysdated-misma-sql-rentorna-cosas-diferentes\/\",\"name\":\"Problemas to_char(sysdate,'D') misma sql rentorna cosas diferentes - Blog Desarrollador\",\"isPartOf\":{\"@id\":\"http:\/\/www.einaweb.es\/develop\/#website\"},\"datePublished\":\"2013-02-08T11:04:45+00:00\",\"dateModified\":\"2013-02-08T11:04:45+00:00\",\"author\":{\"@id\":\"http:\/\/www.einaweb.es\/develop\/#\/schema\/person\/2d3361868423160a6db46ce6f9fc9a3c\"},\"description\":\"Problemas to_char(sysdate,'D') misma sql rentorna cosas diferentes - Blog Desarrollador\",\"breadcrumb\":{\"@id\":\"http:\/\/www.einaweb.es\/develop\/problemas-to_charsysdated-misma-sql-rentorna-cosas-diferentes\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/www.einaweb.es\/develop\/problemas-to_charsysdated-misma-sql-rentorna-cosas-diferentes\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/www.einaweb.es\/develop\/problemas-to_charsysdated-misma-sql-rentorna-cosas-diferentes\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"http:\/\/www.einaweb.es\/develop\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Problemas to_char(sysdate,&#8217;D&#8217;) misma sql rentorna cosas diferentes\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/www.einaweb.es\/develop\/#website\",\"url\":\"http:\/\/www.einaweb.es\/develop\/\",\"name\":\"Blog Desarrollador\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/www.einaweb.es\/develop\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"http:\/\/www.einaweb.es\/develop\/#\/schema\/person\/2d3361868423160a6db46ce6f9fc9a3c\",\"name\":\"Angel Fernandez Gutierrez\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"http:\/\/www.einaweb.es\/develop\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/366f7c75ad085d0dcc2c290559c1aa5947679d86e3a8c55db42ac1c26e16c816?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/366f7c75ad085d0dcc2c290559c1aa5947679d86e3a8c55db42ac1c26e16c816?s=96&d=mm&r=g\",\"caption\":\"Angel Fernandez Gutierrez\"},\"url\":\"http:\/\/www.einaweb.es\/develop\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Problemas to_char(sysdate,'D') misma sql rentorna cosas diferentes - Blog Desarrollador","description":"Problemas to_char(sysdate,'D') misma sql rentorna cosas diferentes - Blog Desarrollador","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":"http:\/\/www.einaweb.es\/develop\/problemas-to_charsysdated-misma-sql-rentorna-cosas-diferentes\/","og_locale":"es_ES","og_type":"article","og_title":"Problemas to_char(sysdate,'D') misma sql rentorna cosas diferentes - Blog Desarrollador","og_description":"Problemas to_char(sysdate,'D') misma sql rentorna cosas diferentes - Blog Desarrollador","og_url":"http:\/\/www.einaweb.es\/develop\/problemas-to_charsysdated-misma-sql-rentorna-cosas-diferentes\/","og_site_name":"Blog Desarrollador","article_published_time":"2013-02-08T11:04:45+00:00","author":"Angel Fernandez Gutierrez","twitter_card":"summary_large_image","twitter_creator":"@afernandezg76","twitter_site":"@afernandezg76","twitter_misc":{"Escrito por":"Angel Fernandez Gutierrez","Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"http:\/\/www.einaweb.es\/develop\/problemas-to_charsysdated-misma-sql-rentorna-cosas-diferentes\/","url":"http:\/\/www.einaweb.es\/develop\/problemas-to_charsysdated-misma-sql-rentorna-cosas-diferentes\/","name":"Problemas to_char(sysdate,'D') misma sql rentorna cosas diferentes - Blog Desarrollador","isPartOf":{"@id":"http:\/\/www.einaweb.es\/develop\/#website"},"datePublished":"2013-02-08T11:04:45+00:00","dateModified":"2013-02-08T11:04:45+00:00","author":{"@id":"http:\/\/www.einaweb.es\/develop\/#\/schema\/person\/2d3361868423160a6db46ce6f9fc9a3c"},"description":"Problemas to_char(sysdate,'D') misma sql rentorna cosas diferentes - Blog Desarrollador","breadcrumb":{"@id":"http:\/\/www.einaweb.es\/develop\/problemas-to_charsysdated-misma-sql-rentorna-cosas-diferentes\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["http:\/\/www.einaweb.es\/develop\/problemas-to_charsysdated-misma-sql-rentorna-cosas-diferentes\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/www.einaweb.es\/develop\/problemas-to_charsysdated-misma-sql-rentorna-cosas-diferentes\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"http:\/\/www.einaweb.es\/develop\/"},{"@type":"ListItem","position":2,"name":"Problemas to_char(sysdate,&#8217;D&#8217;) misma sql rentorna cosas diferentes"}]},{"@type":"WebSite","@id":"http:\/\/www.einaweb.es\/develop\/#website","url":"http:\/\/www.einaweb.es\/develop\/","name":"Blog Desarrollador","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/www.einaweb.es\/develop\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"es"},{"@type":"Person","@id":"http:\/\/www.einaweb.es\/develop\/#\/schema\/person\/2d3361868423160a6db46ce6f9fc9a3c","name":"Angel Fernandez Gutierrez","image":{"@type":"ImageObject","inLanguage":"es","@id":"http:\/\/www.einaweb.es\/develop\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/366f7c75ad085d0dcc2c290559c1aa5947679d86e3a8c55db42ac1c26e16c816?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/366f7c75ad085d0dcc2c290559c1aa5947679d86e3a8c55db42ac1c26e16c816?s=96&d=mm&r=g","caption":"Angel Fernandez Gutierrez"},"url":"http:\/\/www.einaweb.es\/develop\/author\/admin\/"}]}},"_links":{"self":[{"href":"http:\/\/www.einaweb.es\/develop\/wp-json\/wp\/v2\/posts\/52","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.einaweb.es\/develop\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.einaweb.es\/develop\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.einaweb.es\/develop\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.einaweb.es\/develop\/wp-json\/wp\/v2\/comments?post=52"}],"version-history":[{"count":2,"href":"http:\/\/www.einaweb.es\/develop\/wp-json\/wp\/v2\/posts\/52\/revisions"}],"predecessor-version":[{"id":65,"href":"http:\/\/www.einaweb.es\/develop\/wp-json\/wp\/v2\/posts\/52\/revisions\/65"}],"wp:attachment":[{"href":"http:\/\/www.einaweb.es\/develop\/wp-json\/wp\/v2\/media?parent=52"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.einaweb.es\/develop\/wp-json\/wp\/v2\/categories?post=52"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.einaweb.es\/develop\/wp-json\/wp\/v2\/tags?post=52"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}