Postgres Pro
Downloads
Home   >   mailing lists

Re: extracting parts from date values - Mailing list pgsql-general

From Stephan Szabo
Subject Re: extracting parts from date values
Date
Msg-id Pine.BSF.4.21.0102060917470.43759-100000@megazone23.bigpanda.com
Whole thread Raw
In response to extracting parts from date values  (Hubert Palme <palme@uni-wuppertal.de>)
List pgsql-general
Tree view 
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?

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: ON DELETE CASCADE and TRIGGER
Next
From: Fernando del Valle
Date:
Subject: Attribute inhrel not found