MONTH IN WORD FORMATE IN SQL SERVER

Jayden Bell

Total Post:110

Points:774
Posted by  Jayden Bell
 1302  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. AVADHESH PATEL

    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

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!