Re: [MonetDB-users] Convert date field to its proper name

On Fri, 30 Oct 2009, Roman Sokolyuk wrote:

Is there a way to convert a month number to its name? For example, I am executing the following statement: EXTRACT(MONTH FROM signup_date), but I want "1" to display as "January".

Join that column with a list of months? Stefan