title: ORACLE SQL adjust date for timezone without casting to timestamp or char
body: <p>For ORACLE SQL, Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production,</p>
  <p>Is there a way to convert a date (including date/time) from GMT to local time (allowing for Daylight Savings adjustment) directly just as a date (including date/time)?</p>
  <p>I have seen several solutions that involve timestamps or that use timestamps and character conversions with the relevant timezone offset.</p>
  <p>However, I'd like to keep everything as a date.</p>
  <p>Example using timestamp conversion:</p>
  <pre><code>SELECT OUR_DATE, from_tz(cast( OUR_DATE as timestamp), 'GMT') at time zone 'US/Eastern'
  from OUR_DB.OUR_TBL;
  </code></pre>