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());
-- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
