month number of date postgre code example Example: postgres get month name from date SELECT TO_CHAR(TIMESTAMP '2020-12-16 10:41:35', 'Month') AS "Month";