Prev: Help with passing a string variable into a parameter
Next: Update Trigger
From: YC on 11 Mar 2010 16:08
Hi,
How do we spell out numbers like "1, 2, 3..." to words like "January,
February, March..." for month? The database is MySQL.

YC

From: jgurgul on 11 Mar 2010 16:56
Hi YC

The MS SQL Server version can be obtained using:

SELECT DATENAME ( month , dt)

http://msdn.microsoft.com/en-us/library/ms174395.aspx

MySQL is not a microsoft product (so you will need to search online for a
forum).

However the documentation to do what you are after is at:

http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_monthname

mysql> SELECT MONTHNAME('2008-02-03');
-> 'February'

Jon

"YC" wrote:

> Hi,
> How do we spell out numbers like "1, 2, 3..." to words like "January,
> February, March..." for month? The database is MySQL.
>
> YC
>
> .
>
 | 
Pages: 1
Prev: Help with passing a string variable into a parameter
Next: Update Trigger