date_part - Mailing list pgsql-sql

From Rudi Starcevic
Subject date_part
Date
Msg-id 3D0FC011.4010509@oasis.net.au
Whole thread Raw
Responses Re: date_part  (Josh Berkus <josh@agliodbs.com>)
List 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.



pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: text vs varchar
Next
From: Michelle Murrain
Date:
Subject: Re: text vs varchar