Re: First day of month, last day of month

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


--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql