Yeah - I was just wondering if there was a built in facility for the EXTRACT function - like extracting months by name. I will most likely end up doing it programmatically. Thanks. On Fri, Oct 30, 2009 at 11:48 AM, Stefan de Konink <stefan@konink.de> wrote:

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

------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users