time >
order-by-time

Order by time

Order by time DESC
Order by time ASC
Order by cast(___ as datetime)

1)
display the 10 most recent rows 
Select * From (Select * From TB Order by time DESC Limit 10) 
Order by time ASC;

2)
Select * from TB Order by cast(TimeField as datetime)"

1)
get the last 10 (DESC limit 10)

2)
cast(TimeField as datetime)
converts text value to a datetime