Home > DeveloperSection > Forums > month in word formate in sql server
Jayden Bell
Jayden Bell

Total Post:105

Points:739
Posted on    January-25-2013 1:32 AM

 MSSQL Server MSSQL Server 
Ratings:


 1 Reply(s)
 1005  View(s)
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


AVADHESH PATEL

Total Post:604

Points:4228
Posted on    January-28-2013 8:54 AM

Hi Jayden Bell

You can try this line of code

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

Don't want to miss updates? Please click the below button!

Follow MindStick