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.


Wed, 19 Jun 2002 09:19:45 +1000
Rudi Starcevic <rudi@oasis.net.au>
date_part
Rudi,

select to_char(date_column, 'Month');

See similar under "Formatting Function" in the docs.

-- 
-Josh Berkus


Tue, 18 Jun 2002 17:47:08 -0700
Josh Berkus <josh@agliodbs.com>
Re: date_part