MONTH IN WORD FORMATE IN SQL SERVER

Total Post:110

Points:774
 1563  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

NEWSLETTER

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