Answers for "postgres extract example"

SQL
2

get year from date postgres

SELECT EXTRACT(YEAR FROM column_date);
Posted by: Guest on June-01-2020
5

postgresql get year

select extract(year from your_column) from your_table;
Posted by: Guest on May-26-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language