title: Convert from PDT to GMT or PST to GMT based date-time in the Column of a Table
body: <p>I am stuck with a finding out and converting date from one of my database column. The database I am using is Oracle.</p>
  
  <p>My database column saves the data in PST or PDT depending on the time of the year the entry was done.</p>
  
  <p>For example - in US the local time changes from PST to PDT at 02:00 LST to 03:00 LDT on the second Sunday in March and the time returns at 02:00 LDT to 01:00 LST on the first Sunday in November.</p>
  
  <p>So in my target i have one extra column which will be storing the date in GMT format.</p>
  
  <p>So please help me to handle the situation and store the result from Source to target.</p>
  
  <p>Source table:</p>
  
  <pre><code>Request_ID, Requested_by, Added_Day
  </code></pre>
  
  <p>Target table:</p>
  
  <pre><code>Request_ID, Requested_by, Added_Day, Added_Day_INGMT
  </code></pre>
  
  <p>The Added Day in the Source will have data in PDT as well as PST based on the day it got added as explained in above example.</p>
  
  <p>And in Target i want the corresponding Added_day to be saved in Added_Day_INGMT after converting it to GMT.</p>
  
  <p>Please help me to do it. I am clueless because the same column has data for PDT as well as PST and it has to be handled accordingly while converting it to GMT</p>
  
  <p>Thanks.</p>