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) =
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.
In response to
pgsql-sql by date
|Next:||From: Erik Jones||Date: 2008-04-24 14:41:04|
|Subject: Re: First day of month, last day of month|
|Previous:||From: Volkan YAZICI||Date: 2008-04-24 13:53:15|
|Subject: Re: How I can check a substring is a valid number in postgresql ?|