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());