MSSql : convert dd/mm/yyyy (’24/02/2008′) to MMM/dd/YYYY (’Feb/24/2008′)? « Vijay Modi

Posted by: Vijay Modi | May 17, 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

Posted in MS Sql Server

Leave a response

Categories