{"id":115,"date":"2024-12-27T19:20:25","date_gmt":"2024-12-27T22:20:25","guid":{"rendered":"https:\/\/recover.rdconsolo.com.br\/?p=115"},"modified":"2024-12-27T19:20:25","modified_gmt":"2024-12-27T22:20:25","slug":"campos-data-de-bancos-mysql-no-pdi","status":"publish","type":"post","link":"https:\/\/rdconsolo.com.br\/?p=115","title":{"rendered":"Campos DATA de bancos MySQL no PDI"},"content":{"rendered":"\n<p>Dependendo da vers\u00e3o das bibliotecas de acesso a um banco MySQL, o Pentaho pode retornar erro ao ler colunas do tipo DATE, especialmente no que se refere \u00e0 interpreta\u00e7\u00e3o do fuso hor\u00e1rio.<\/p>\n\n\n\n<p>A mensagem que normalmente aparece \u00e9<\/p>\n\n\n\n<p><strong>HOUR_OF_DAY: 0 -&gt; 1<\/strong><\/p>\n\n\n\n<p>Definindo o fuso hor\u00e1rio nas op\u00e7\u00f5es de carga dos aplicativos do PDI resolve esse problema. Por exemplo, colocando a defini\u00e7\u00e3o<strong> \u201c-Duser.timezone=GMT-3\u201d<\/strong> dentro do <strong>spoon.bat<\/strong> na linha <strong>set OPT=\u2026<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dependendo da vers\u00e3o das bibliotecas de acesso a um banco MySQL, o Pentaho pode retornar erro ao ler colunas do tipo DATE, especialmente no que se refere \u00e0 interpreta\u00e7\u00e3o do fuso hor\u00e1rio. A mensagem que normalmente aparece \u00e9 HOUR_OF_DAY: 0 -&gt; 1 Definindo o fuso hor\u00e1rio nas op\u00e7\u00f5es de carga dos aplicativos do PDI resolve &hellip; <a href=\"https:\/\/rdconsolo.com.br\/?p=115\" class=\"more-link\">Continue lendo<span class=\"screen-reader-text\"> &#8220;Campos DATA de bancos MySQL no PDI&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[30],"tags":[25],"class_list":["post-115","post","type-post","status-publish","format-standard","hentry","category-developer","tag-mysql"],"_links":{"self":[{"href":"https:\/\/rdconsolo.com.br\/index.php?rest_route=\/wp\/v2\/posts\/115","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rdconsolo.com.br\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rdconsolo.com.br\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rdconsolo.com.br\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rdconsolo.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=115"}],"version-history":[{"count":1,"href":"https:\/\/rdconsolo.com.br\/index.php?rest_route=\/wp\/v2\/posts\/115\/revisions"}],"predecessor-version":[{"id":116,"href":"https:\/\/rdconsolo.com.br\/index.php?rest_route=\/wp\/v2\/posts\/115\/revisions\/116"}],"wp:attachment":[{"href":"https:\/\/rdconsolo.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=115"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rdconsolo.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=115"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rdconsolo.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=115"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}