how to extract month of year from timestamp in postgressql code example Example: postgresql get year select extract(year from your_column) from your_table;