title: How to truncate date in postgres?
body: <p>I am using below condition to truncate date in postgres</p>
  <pre><code>to_date(to_char(trunc(appointment_date),'YYYYMMDD')||appointment_end_time,''YYYYMMDDHH24:MI:SS')AS tq
  </code></pre>
  <p>How I can use this in postgres ?</p>