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

Re: Problem with selecting the first day of the the week

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: x asasaxax <xanaruto(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem with selecting the first day of the the week
Date: 2008-10-29 20:46:07
Message-ID: 4908CB8F.3060205@iol.ie (view raw or flat)
Thread:
Lists: pgsql-general
On 29/10/2008 20:11, x asasaxax wrote:

>    I need a function to select the first day of the week. For example
> giving  today┬┤s date(29/10/2008).

select 'Monday';

;-)


Ray.


------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

In response to

pgsql-general by date

Next:From: WaGathoniDate: 2008-10-29 20:59:44
Subject: Group BY
Previous:From: Pavel StehuleDate: 2008-10-29 20:40:41
Subject: Re: Problem with selecting the first day of the the week

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