I am trying to build a query sql that select all rows in my table with a spesific month (format timestamp, yyy-mm-dd hh:mm:ss), for example, all of january, select * from table where field_date = 01. but i don't know the specific query
select * from table where extract(month from field) = 1; Chris
