Extract year and month from date in postgresql July 8, 2019 16 32 64 128 Extract year from date in postgresql Extract year from date postgresql in where clause