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:)

Advertisements

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 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:

    http://www.sqlhub.com/2009/04/list-of-all-available-datetime-format.html

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s