title: Oracle local timezone
body: <p>I'm using this expression to convert a date at UTC to its US/Eastern time equivalent:</p>
  
  <pre><code>CAST((FROM_TZ(CAST(date_field AS TIMESTAMP),'+00:00') AT TIME ZONE 'US/Eastern') AS DATE) DATE_FIELD_ET
  </code></pre>
  
  <p>I was hoping to use a more generic expression to cast the value to the local time:</p>
  
  <pre><code>CAST((FROM_TZ(CAST(note_time AS TIMESTAMP),'+00:00') AT LOCAL TIME ZONE) AS DATE) DATE_FIELD_LOCAL
  </code></pre>
  
  <p>But this syntax doesn't work.</p>
  
  <p>Is there a way to do this?</p>