month in word formate in sql server

Total Post:110

Points:774
 1621  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. Post:604

    Points:4228
    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