[MonetDB-users] Convert date field to its proper name
Hi, 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". Thanks.
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
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
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
participants (2)
-
Roman Sokolyuk -
Stefan de Konink