mysql query about listing in proper way

I want a round robin listing where time near to the system time comes earlier and then the time that have passed comes later on when listed for the same date. the query should be only one.