month name from the sql query

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

Re: month name from the sql query

sachin shah (sachin28880@gmail.com) writes:
> 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@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx

Re: month name from the sql query

On Aug 16, 7:48 am, sachin shah wrote:
> 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())