Re: extracting parts from date values

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Hubert Palme <palme(at)uni-wuppertal(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: extracting parts from date values
Date: 2001-02-06 17:19:16
Message-ID: Pine.BSF.4.21.0102060917470.43759-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


You should be able to use date_part()
[date_part('month', <value>), date_part('day', <value>)]

On Sat, 3 Feb 2001, Hubert Palme wrote:

> Hi,
>
> How can I extract parts (e.g. month or day) from date values?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-02-06 17:27:54 Re: Attribute inhrel not found
Previous Message Brett W. McCoy 2001-02-06 17:15:56 Re: permissions on databases