forum

Home / DeveloperSection / Forums / month in word formate in sql server

month in word formate in sql server

Jayden Bell211325-Jan-2013

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

Updated on 28-Jan-2013

Can you answer this question?

Answer

28-Jan-2013

Hi Jayden Bell

You can try this line of code

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