title: How can I convert time to a number format in oracle for a specific timezone
body: <p>My database shows the time in GMT.</p>
  
  <p>I am able to convert the hour and minute part of it in number by doing:</p>
  
  <p><code>TO_NUMBER(TO_CHAR(CORE_UPDATE_TS, 'HH24MI'))</code></p>
  
  <p>where core_update_ts is the value received from database. However, my requirement is to convert the core_update_ts into America/Los_Angeles and then change it to Number.</p>
  
  <p>I am not able to do this specific task. When I do,</p>
  
  <pre><code>to_number(to_char((from_tz(to_timestamp(to_char(CORE_UPDATE_TS, 'YYYY-MM-DD HH24:MI'),
  'YYYY-MM-DD HH24:MI') ,'GMT') at time zone 'America/Los_Angeles'),'DD-MON-YYYY
  HH24:MI'), 'HH24MI') i am getting error.
  </code></pre>
  
  <p>How can I do this?</p>