s

Home > postgresql > postgresql month name from date

postgresql month name from date edit button Edit

author
Murugan Andezuthu Dharmaratnam | calendar 22 September 2021 | 1296

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