Hi!! I am using postgresql 7.3 and I have a table with one timestamp without zone field (date1), I want to select any row when "date1" is between inicial_date and final_date values, I'm using an Sql sentence like this:
SELECT name, date1, ......
FROM table_name
WHERE date1>=inicial_date and date1<=final_date
it works fine if month of field "date1" is the same in "inicial_date" and "final_date", but if month value of "date1" is different the result is always NULL, any idea??????
please help me!!!