SELECT trim(leading '0' from to_char(now(), 'HH:MM AM')) I think is what you really want. This gets rid of the nasty leasing 0.
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных