how to add AM or PM in PostgreSQL in date format itself?

Question

select to_date(to_char(sysdate,'yyyy-mm-dd hh12:mi:ss AM'), 'yyyy-MM-dd HH12:MI:SS AM') from dual;

This works fine in oracle but not in Postgres.

Answer 1

Instead of sysdate you should use current_timestamp, or now():

SELECT TO_CHAR(current_timestamp, 'yyyy-mm-dd hh12:mi:ss AM')

Answer 2

A table for add AM or PM format itself.

create table date_tbl ( id serial, Date_time varchar (30) default TO_CHAR(current_timestamp, 'yyyy-mm-dd hh:mi:ss AM') )