date_part

From: Rudi Starcevic <rudi(at)oasis(dot)net(dot)au>
To: pgsql-sql(at)postgresql(dot)org
Subject: date_part
Date: 2002-06-18 23:19:45
Message-ID: 3D0FC011.4010509@oasis.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

Hi,

When using the date_part function is it possible to get the month name
and not the month number ?
I'm using something like 'date_part('month', birth_date)' - birth_date
being a date data type.

Currently I'm getting numbers from 1 to 12 whereas I'd like the full
name like 'June' or 'July' etc.

Thanks
Rudi.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroshi Inoue 2002-06-19 00:11:44 Re: SetQuerySnapshot, once again
Previous Message Dann Corbit 2002-06-18 22:40:29 Re: ECPG won't compile anymore

Browse pgsql-sql by date

  From Date Subject
Next Message Michelle Murrain 2002-06-18 23:31:46 Re: text vs varchar
Previous Message Josh Berkus 2002-06-18 22:59:54 Re: text vs varchar