to_char

date_format的なアレはPostgreにはない

SELECT to_char(CURRENT_TIMESTAMP, 'YYYY-MM-DD HH12:MI:SS'),
       to_char(CURRENT_TIMESTAMP, 'YYYY-MM-DD HH24:MI:SS')

https://www.postgresql.jp/document/9.4/html/functions-formatting.html