Answers for "pgsql select dates in year sql"

SQL
5

postgresql get year

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

postgre query date

SELECT * FROM data WHERE date = '2020-12-21'
Posted by: Guest on September-15-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language