Answers for "postgres, select by year and month"

get year from date postgres

SELECT EXTRACT(YEAR FROM column_date);

Posted by: Guest on June-01-2020

postgres get month name from date

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

Posted by: Guest on November-18-2020

Code answers related to "postgres, select by year and month"