how to display in desc order by date not time : <p>[how to display in desc order by date not time]</p>

<p>I am using the SELECT * from alarms ORDER BY time_date DESC. it will display the output according to time in descending order but we display the descending order by date not time.</p>

<p>My sql structure is for time_date fields:</p>

<p>1) 23:48:17 05-04-2016
 2) 23:20:42 31-03-2016
 3) 22:06:29 03-04-2016
 4) 21:48:31 28-03-2016</p>
