Rajasekhar G

Rajasekhar G

  • NA
  • 2
  • 559

Date and Time Asc and desc

Jun 7 2017 3:00 AM
hi
i have one table which contains date column(mm/dd/yyyy) and Time(hh:mm:ss t) column separately.both are in varchar data type now how can i get in asc order or desc order like as follows 
mm/dd/yyyy and hh:mm:ss t 
05/27/2017  and 04:33:45 PM
05/27/2017 and 04:32:00 am 
 04/01/2017 and 05:30:00 PM
03/01/2017 and 10:30:00 Am
 
please refer following 
please give the solution.
i need changes in varchar data type only not in datetime data type. 
 

Answers (2)