From: | "Bart Degryse" <Bart(dot)Degryse(at)indicator(dot)be> |
---|---|
To: | "Colin Wetherbee" <cww(at)denterprises(dot)org>, "Nacef LABIDI" <nacef(dot)l(at)gmail(dot)com> |
Cc: | <pgsql-sql(at)postgresql(dot)org>, "Frank Bax" <fbax(at)sympatico(dot)ca> |
Subject: | Re: First day of month, last day of month |
Date: | 2008-04-24 14:47:14 |
Message-ID: | 4810B991.A3DD.0030.0@indicator.be |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Well, that's what it does afaikt.
>>> "Nacef LABIDI" <nacef(dot)l(at)gmail(dot)com> 2008-04-24 16:43 >>>
Actually I want to select all rows whith dates between first day of the month 00:00:00 and last date of the month 23:59:59
On Thu, Apr 24, 2008 at 4:15 PM, Colin Wetherbee <cww(at)denterprises(dot)org> wrote:
Frank Bax wrote:
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());
I have some code that uses extract() for this sort of thing. Would you mind explaining how date_trunc() is better for this?
Most of my extract() results end up in <select> drop-down boxes in HTML.
Thanks.
Colin
From | Date | Subject | |
---|---|---|---|
Next Message | Terry Lee Tucker | 2008-04-24 14:52:43 | Re: First day of month, last day of month |
Previous Message | Nacef LABIDI | 2008-04-24 14:43:40 | Re: First day of month, last day of month |