Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

month name from the sql query

0 views

Skip to first unread message

unread,

Aug 16, 2007, 2:48:37 AM8/16/07

Hi all

i want result as month name from my query

i tried with the following query but it give result as month number
like (8)

select (month(getdate())) as expr

i want result as month name (Augest)..

give me the proper query...

from Sachin

unread,

Aug 16, 2007, 3:12:26 AM8/16/07

Look at the datename() function in Books Online.

--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

unread,

Aug 16, 2007, 4:38:28 AM8/16/07

Try SELECT DATENAME(MONTH,GETDATE())

0 new messages