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),’ ‘,’/’)



About Vijay Modi

Having 12+ years of experience in web application development. Expertise in various domains like E-Commerce, E-Learning, Insurance. I have expertise in web application development, window application development, Performance improvement, bug fixing etc. I have worked on various Microsoft technologies including ASP.Net, MVC, WebApi, WCF, Entity Framework, WPF, Window Application Development, AWS, Azure, AngularJS 2.0 / 1.5.2, .NetCore framework, jQuery. I am believing in quality work and achieving deadlines. Also like to work on new technologies and quick learner.
This entry was posted in Uncategorized and tagged . Bookmark the permalink.

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

  1. riteshshahh says:

    apart from format no. 109, there are many, reader can get the list of other formats too…. from this link:

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s