-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi all I've been searching for a solution to the following:
Is there an easy way to order by date (YYYY - MM - DD), at the moment my results are coming back with the *day* ordered but not the whole date like this: 02 02 2002 03 03 2005 18 02 2003 See what I mean? I can't beleive there is nothing that can be done with sql about this but I can't seem to find anything that will tell me how to do it so a little pointer would be smashing. Many thanks... - -- Nick Wilson // www.explodingnet.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE815hbHpvrrTa6L5oRAtdGAJ9MhgAcbdHqQnBJpfRPHGCf3msHvQCeLq0S qL5vUD6SumKXFFL/mOnhp/0= =k44P -----END PGP SIGNATURE----- --------------------------------------------------------------------- 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