title: Convert timestamp to DATE format (MM-DD-YYYY) using postgers sql
body: <p>I have a function written in postgres sql.
  The function is returning value using return table.
  The table value from where I'm fetching the data is timestamp but while returning I need to convert the timestamp to date format like MM-DD-YYYY while fetching the records.
  Table should have only date as value</p>
  <p><code>RETURNS TABLE(employee_id character varying,  effective_date timestamp )</code></p>
  <p><code>BEFORE 2020-05-08 00:00:00</code></p>
  <p><code>AFTER 05-082020</code></p>
  <p>It would be helpful if anyone can guide me to return the value in date format.</p>