title: Comparing Datetime in Oracle
body: <p>Do I need to convert <code>TIMESTAMP</code> to <code>DATE</code> before doing a comparison? EX:</p>
  
  <pre><code>AND SORD.CREATED &gt;= TO_DATE(FROM_TZ(CAST(TO_DATE('','DD-MON-YYYY HH24:MI:SS') AS TIMESTAMP), 'Asia/Kuala_Lumpur') AT TIME ZONE 'UTC','DD-MON-YYYY HH24:MI:SS')
  AND SORD.CREATED &lt; TO_DATE(FROM_TZ(CAST(TO_DATE('','DD-MON-YYYY HH24:MI:SS') AS TIMESTAMP), 'Asia/Kuala_Lumpur') AT TIME ZONE 'UTC','DD-MON-YYYY HH24:MI:SS')
  </code></pre>
  
  <p>Just looking for an opinion, since I'm still new and learning about databases.</p>