month in word formate in sql server

Total Post:110

Points:774

 1748  View(s)
Ratings:
Rate this:
Hi Everyone!

I want to display month in word formate in SQL server 2008. e.g. 25 Jan 2013 00:00:00. can you help me?

Thanks in advance
  1. Re: month in word formate in sql server

    Hi Jayden Bell

    You can try this line of code

    SELECT CONVERT(VARCHAR(50),GETDATE(),113)

Answer

Please check, If you want to make this post sponsored

You are not a Sponsored Member. Click Here to Subscribe the Membership.