Sunday, February 24, 2008

MSSql : convert dd/mm/yyyy ('24/02/2008') to MMM/dd/YYYY ('Feb/24/2008')?

Its just simple. Try the following query and it will give you the result.

SELECT REPLACE(convert(varchar(11), getdate(), 109),' ','/')

Enjoy:)

MSSql : convert dd/mm/yyyy (‘24/02/2008′) to MMM/dd/YYYY (‘Feb/24/2008′)?

Its just simple. Try the following query and it will give you the result.

SELECT REPLACE(convert(varchar(11), getdate(), 109),’ ‘,’/')