Posted by stephen on 08/16/07 08:38

On Aug 16, 7:48 am, sachin shah <sachin28...@gmail.com> 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())

• Next in forum: Re: Restoring from Backup without logs
• Prev in forum: Re: standard and easy way to do schema design
• Thread view: Re: month name from the sql query

[Reply to this message]