如何根据时间显示记录[关闭]

there is many records stored in my table in time colomn, i want to display the records according to time, like: first records should be 12:00 AM Second one of after 12:00 AM and so on.

table name: appointment
colomn name: time time format: 12:00 AM

the records should be from 12:00 AM to 12:00 PM

 select * from table_name order by time desc

Try sorting the data by time:

SELECT *
FROM MyTable
--where mydate =..???
ORDER BY mydate