At 07:22 AM 3/9/05, enzo venegas palacios wrote:
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
WHERE date_part('month',field_date) = 01