select * from mytable where date_trunc('month', mydate) = date_trunc('month', now());
>>> Frank Bax <fbax(at)sympatico(dot)ca> 2008-04-24 15:06 >>>
Nacef LABIDI wrote:
> is there a better method to retrieve all
> the rows with dates in the current month.
select * from mytable where extract(month from mydate) = extract(month
from now()) and extract(year from mydate) = extract(year from now());