title: Oracle Timezone - Brazil 2018 change
body: <p>Similar to the issue described in the <a href="https://stackoverflow.com/questions/52928931/java-daylight-daylight-saving-seems-to-be-wrong">post</a>: </p>
  
  <p>But for Oracle database itself.</p>
  
  <p>There's a database running on machine whose timezone/clock is set to <em>Brazil/East/Brasilia/SaoPaulo time</em>. We use this query to get the database clock and convert it to <em>GMT</em>: </p>
  
  <pre><code>SELECT to_char(sysdate, 'YYYY-MM-DD HH24:MI') AS MY_SYSDATE
  , TO_CHAR(FROM_TZ (CAST (SYSDATE AS TIMESTAMP), 'America/Sao_Paulo') AT TIME ZONE 'GMT'
  , 'YYYY-MM-DD HH24:MI') as gmt_brazil_east
  , TO_CHAR(FROM_TZ (CAST (SYSDATE AS TIMESTAMP), 'Etc/GMT+3') AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI') as gmt_03
  FROM DUAL
  WHERE 1=1
  ;
  </code></pre>
  
  <p>Every since this past weekend, the value for the field "gmt_brazil_east" is wrong... I suspect because our Oracle hasn't been updated to reflect the recent change regarding when Brazil changes daylight-savings... Described <a href="https://en.wikipedia.org/wiki/Daylight_saving_time_in_Brazil" rel="nofollow noreferrer">here</a>: </p>
  
  <p>Though our database version is recent, it is <em>Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production</em></p>
  
  <p>I tried finding info on this similar to the Java-related post above, but could not... Does anyone know where I can find which version/patch of Oracle has this change to Brazil timezone corrected?</p>