Skip site navigation (1) Skip section navigation (2)

Re: First day of month, last day of month

From: Colin Wetherbee <cww(at)denterprises(dot)org>
To: Frank Bax <fbax(at)sympatico(dot)ca>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: First day of month, last day of month
Date: 2008-04-24 14:15:23
Message-ID: 481095FB.7090600@denterprises.org (view raw or flat)
Thread:
Lists: pgsql-sql
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


In response to

Responses

pgsql-sql by date

Next:From: Erik JonesDate: 2008-04-24 14:41:04
Subject: Re: First day of month, last day of month
Previous:From: Volkan YAZICIDate: 2008-04-24 13:53:15
Subject: Re: How I can check a substring is a valid number in postgresql ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group