Message-ID: <48108813.6070401@sympatico.ca>
Date: Thu, 24 Apr 2008 09:16:03 -0400
From: Frank Bax <fbax@sympatico.ca>
User-Agent: Thunderbird 2.0.0.6 (X11/20070818)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Re: First day of month, last day of month
References: <f16f7ea00804240559y6694c19fx102e57ea4455b07d@mail.gmail.com>
	<481085D1.2010807@sympatico.ca>
In-Reply-To: <481085D1.2010807@sympatico.ca>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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