Frank Bax wrote:
> 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());
Sorry; I was not thinking clearly - date_trunc is better for this:
select * from mytable where date_trunc('month',mydate) =
date_trunc('month',now());