Answers for "postgres query date a year"

get year from date postgres

SELECT EXTRACT(YEAR FROM column_date);

Posted by: Guest on June-01-2020

postgre query date

SELECT * FROM data WHERE date = '2020-12-21'

Posted by: Guest on September-15-2020

Code answers related to "postgres query date a year"