I'm sure this won't matter, but did you try putting a "order by date_close DESC" or "ASC"?
Daevid Vincent http://daevid.com > -----Original Message----- > From: Elton [mailto:[EMAIL PROTECTED] > Sent: Monday, December 01, 2003 9:04 AM > To: [EMAIL PROTECTED] > Subject: Re: datetime ORDER BY is erred > > Oops, my pasted graphic did not pass; here is what I get: > > mysql> select date_close,aircraft,route from Avail_Legs Order By > date_close; > +---------------------+----------+-----------+ > | date_close | aircraft | route | > +---------------------+----------+-----------+ > | 2003-11-01 14:00:00 | GII | MSL - FLL | > | 2003-09-12 17:42:29 | GII | NYC - MSL | > | 2003-10-01 11:00:02 | GII | FLL - MSL | > +---------------------+----------+-----------+ > 3 rows in set (0.00 sec) > > mysql> > > Which is wrong. > > > Again, any advise would be appreciated. > > > Elton > > On Dec 1, 2003, at 10:51 AM, Elton wrote: > > > I'm using MySQL v4.0.14 that ships with Panther_Server. I > have been > > trying to get it to sort datetime fields properly without success; > > this is what I get: > > > > > > > > Is this a known bug? Is there a workaround? > > > > Any help would be appreciated. > > > > > > Elton > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
