SELECT  POST_CRTE_DT
,       TO_CHAR(POST_CRTE_DT, 'YYYY-MM-DD HH24:MI:SS.MS TZHTZM')

,       TO_TIMESTAMP('2022-08-06 22:11:36.582 +0900', 'YYYY-MM-DD HH24:MI:SS.MS TZHTZM')

,       EXTRACT(YEAR    FROM POST_CRTE_DT) AS YYYY
,       EXTRACT(MONTH   FROM POST_CRTE_DT) AS MM
,       EXTRACT(DAY     FROM POST_CRTE_DT) AS DD

,       EXTRACT(HOUR    FROM POST_CRTE_DT) AS HH24
,       EXTRACT(MINUTE  FROM POST_CRTE_DT) AS MI
,       EXTRACT(SECOND  FROM POST_CRTE_DT) AS SS

,       EXTRACT(TIMEZONE_HOUR   FROM POST_CRTE_DT) AS TZH
,       EXTRACT(timezone_minute FROM POST_CRTE_DT) AS TZM

FROM BLOG_POST
ORDER BY POST_CRTE_DT DESC;

TO_CHAR, TO_TIMESTAMP : https://www.postgresql.org/docs/12/functions-formatting.html

EXTRACT : https://www.postgresql.org/docs/12/functions-datetime.html