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.