title: sysdate and dbtimezone different in Oracle Database
body: <p>With this query: <code>select sysdate from dual;</code></p>
  
  <p>the result is: <code>27-09-2018 07:50:50</code>  -- this <code>UK</code> time</p>
  
  <p>with : <code>Select dbtimezone from dual;</code></p>
  
  <p>output: <code>+10:00</code></p>
  
  <p>I want the <code>sysdate</code> to be of the same timezone of <code>dbtimezone</code></p>
  
  <p>I was trying to do it with <code>alter database set time_zone='AEST'</code>, but i'm bit confused if this is the right solution.</p>
  
  <p>Any help most appreciated.
  Thanks.</p>