On Wed, 2004-06-16 at 12:49, Jorge Grippo wrote: > Hi Yuval > > Prepare your queries with date_format to return the dates in the format: > YYYYMMDD > After that you can use 'sort' to sort them. > > Jorge I also need it to sort by hour, minute, and a lot of times even second. Maybe if I s/[-:\s]//; I could <=> it (thanks Gaal)... --Yuval