There are various way to get year and month from date in PostgreSQL. 1. Extract The extract function retrieves subfields such as year or hour from date/time values. source must be a value expression…