PostgreSQL EXTRACT: Extracting Year, Month, Day, etc., from ... code example

Example: postgresql get year

select extract(year from your_column) from your_table;