How do I order by the time in a datetime field?
my table looks like this:
2005-07-20 08:00:00 2005-07-20 01:00:00 2005-07-20 10:00:00
Thanks for the help!
ORDER BY columnname orders by date and time
if you only want to order by time: ORDER BY SUBSTRING_INDEX(columnname, ' ', -1) to have mysql only check the part after the last blank
