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:ehd@stripped]
> Sent: Monday, December 01, 2003 9:04 AM
> To: mysql@stripped
> 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/mysql?unsub=1
>
