select * from mytable where date_trunc('month', mydate) = date_trunc('month', now());<br /><br /><br />>>>
FrankBax <fbax@sympatico.ca> 2008-04-24 15:06 >>><br />Nacef LABIDI wrote:<br />> is there a better
methodto retrieve all <br />> the rows with dates in the current month.<br /><br /><br />select * from mytable where
extract(monthfrom mydate) = extract(month <br />from now()) and extract(year from mydate) = extract(year from
now());<br/><br />-- <br />Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)<br />To make changes to your
subscription:<br/><a
href="http://www.postgresql.org/mailpref/pgsql">http://www.postgresql.org/mailpref/pgsql</a>-sql<br/>