title: Convert sysdate into CET and CEST time with the help of UTC package functions in oracle
body: <p>I have a requirement where sysdate appears like this 19/01/2015 13:22:05</p>
  
  <p>and i want to convert the the sysdate into CET time which will be        <code>19/01/2015 14:22:05</code></p>
  
  <p>and again i want to convert the sysdate into CEST which will be          <code>19/01/2015 15:22:05</code></p>
  
  <pre><code>select to_char(sysdate , 'DD/MM/YYYY HH24:MI:SS') actual ,
  to_char(utc.get_local_date(sysdate ,'LOCATION') ,'DD/MM/YYYY HH24:MI:SS') cet,
  to_char(utc.get_local_date(sysdate ,'LOCATION')+1/24 ,'DD/MM/YYYY HH24:MI:SS')  cest
  FROM dual 
  </code></pre>
  
  <p>and here location is using <code>Europe/Amsterdam</code> timezone.</p>
  
  <p>Please suggest is there anyway we can achieve CET and CEST timing without hardcoding +1/24 in the sql and by using UTC package functions.</p>
  
  <p>Please correct me if i am wrong ..</p>