title: how to add AM or PM in PostgreSQL in date format itself?
body: <p>select to_date(to_char(sysdate,'yyyy-mm-dd hh12:mi:ss AM'), 
       'yyyy-MM-dd HH12:MI:SS AM') from dual;</p>
  
  <p>This works fine in oracle but not in Postgres.</p>