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; will return: | 2001-11-20 02:53:32 | 3076 | "Simpsons" collections coming next year | 2001-11-20 10:02:06 | 3073 | Pearl Harbor | 2001-11-20 11:05:45 | 3074 | Simpsons season 2 at the BBFC ? | 2001-11-20 12:15:02 | 3075 | Paramount announce "Down to Earth" Note articleid 3076 is timestamped 02 in the afternoon. Article 3075 is 12:15 noon. Clearly article 3076 should come after 3075. Can I set the select query to deal with the order by 24 hour clock or am I missing something big time here ! Andy C Editor R2 project http://www.r2-dvd.org --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
