Order by reservation.time JW
On Tuesday, September 28, 2010, Chris W <[email protected]> wrote: > I have the following query that is giving me problems. > > SELECT DATE_FORMAT(`Time`, '%h:%i%p') as `Time` > FROM `reservation` > ORDER BY `Time` > > Problem is it sorts wrong because of the date format function output with am > and pm. I guess I should have named things differently but I would rather > not do that. Is there a standard way to get around this and have it sort by > the non-formatted time value? > > > Chris W > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[email protected] > > -- ----------------------------- Johnny Withers 601.209.4985 [email protected] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[email protected]
