Let me be a little bit more clear on that...
There are two columns
CurrentDate Date,
Time Varchar(10)
If I do , Select * from Data
Order By Date Desc , Time Desc shows the following results
The result is :
2014-03-26 3:01 AM
2014-03-26 2:01 PM
2014-03-26 2:01 AM
2014-03-26 12:01 PM
2014-03-26 12:01 AM
2014-03-26 11:01 AM *********** Shouldn't this be on top of :01 am?
I need to see the latest Date and Time in an order... If I resolve this I will be able to resolve my issue.