postgresql month name from date Edit

Murugan Andezuthu Dharmaratnam | 22 September 2021 | 824

How to get month name from date in postgresql

Solution

SELECT TO_CHAR(TIMESTAMP '2020-12-16 10:41:35', 'Month') AS "Month";

Result

 December