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.<br>Thanks.<br><br><div class="gmail_quote">On Fri, Oct 30, 2009 at 11:48 AM, Stefan de Konink <span dir="ltr">&lt;<a href="mailto:stefan@konink.de">stefan@konink.de</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div></div><div class="h5">On Fri, 30 Oct 2009, Roman Sokolyuk wrote:<br>
<br>
&gt; Is there a way to convert a month number to its name?<br>
&gt; For example, I am executing the following statement: EXTRACT(MONTH FROM<br>
&gt; signup_date), but I want &quot;1&quot; to display as &quot;January&quot;.<br>
<br>
</div></div>Join that column with a list of months?<br>
<br>
<br>
Stefan<br>
<br>
<br>
------------------------------------------------------------------------------<br>
Come build with us! The BlackBerry(R) Developer Conference in SF, CA<br>
is the only developer event you need to attend this year. Jumpstart your<br>
developing skills, take BlackBerry mobile applications to market and stay<br>
ahead of the curve. Join us from November 9 - 12, 2009. Register now!<br>
<a href="http://p.sf.net/sfu/devconference" target="_blank">http://p.sf.net/sfu/devconference</a><br>
_______________________________________________<br>
MonetDB-users mailing list<br>
<a href="mailto:MonetDB-users@lists.sourceforge.net">MonetDB-users@lists.sourceforge.net</a><br>
<a href="https://lists.sourceforge.net/lists/listinfo/monetdb-users" target="_blank">https://lists.sourceforge.net/lists/listinfo/monetdb-users</a><br>
</blockquote></div><br>