QOTD
   

You must login to the site to see available quizzes.

 
   
By Amal Dev on Tuesday, April 26, 2011 1:46 AM

I have a table with only one column which stores  date values as shown below.

 

Now I want to sort the data in the descending order of the date and needs to display it in the mm/dd/yyyy format. So,

 Select Convert(VarChar(10),FeedDate,103) FeedDate  From Test Order By FeedDate Desc 

The result I got was as follows


By Amal Dev on Monday, April 18, 2011 8:29 PM





Kerala Microsoft Usergroup (K-MUG) is pleased to invite you to the Windows Azure Camp – a 1- day deep dive session designed to help you speed up on developing for Windows Azure. The Windows Azure platform is a flexible cloud-computing platform that lets your customer focus on solving their business problems
 
For more details please visit Azure Camp.
Register for the event here
 
   
ASP.NET
Categories
   
Search
   
Archives
   
Privacy Statement | Terms Of Use | Copyright 2012 by www.techrepository.in