AIL PROTECTED]>
To: "Andy" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: 20 November 2001 15:47
Subject: Re: 24 hour query confusion
> 3076 is 2:53 in the morning, not the afternoon.
>
> On Tuesday 20 November 2001 08:46 am, Andy wrote:
> > Summary
> &g
3076 is 2:53 in the morning, not the afternoon.
On Tuesday 20 November 2001 08:46 am, Andy wrote:
> Summary
> If I have a filed of type "DATETIME" in a table and do a query with an
> order on that field than records with a datetime in the afternoon are
> returned before articles in the morning.
>
Summary
If I have a filed of type "DATETIME" in a table and do a query with an order
on that field than records with a datetime in the afternoon are returned
before articles in the morning.
EG:
mysql> select pubtime,articleid,headline from articles where articleid
mysql> >3050 order by pubtime;
