month name from the sql query

#1

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

#2

sachin shah (sachin28880 (AT) gmail (DOT) com) writes:

Quote:

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...

Look at the datename() function in Books Online.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#3

On Aug 16, 7:48 am, sachin shah <sachin28... (AT) gmail (DOT) com> wrote:

Quote:

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

Try SELECT DATENAME(MONTH,GETDATE())

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

month name from the sql query

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

month name from the sql query - 08-16-2007 , 01:48 AM

Re: month name from the sql query - 08-16-2007 , 02:12 AM

Re: month name from the sql query - 08-16-2007 , 03:38 AM