forum

home / developersection / forums / month in word formate in sql server

month in word formate in sql server

Jayden Bell 2387 25-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

mssql server

Updated on 28-Jan-2013

Jayden Bell

Other

Message

Can you answer this question?

1 Answers

28-Jan-2013

Hi Jayden Bell

You can try this line of code

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

MindStick Training