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

Re: First day of month, last day of month

From: Frank Bax <fbax(at)sympatico(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: First day of month, last day of month
Date: 2008-04-24 13:16:03
Message-ID: 48108813.6070401@sympatico.ca (view raw or flat)
Thread:
Lists: pgsql-sql
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());

In response to

Responses

pgsql-sql by date

Next:From: Anoop GDate: 2008-04-24 13:34:50
Subject: How I can check a substring is a valid number in postgresql ?
Previous:From: A. KretschmerDate: 2008-04-24 13:15:36
Subject: Re: First day of month, last day of month

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