-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
* and then Jay Blanchard declared.... > If the date is in the format above you can select a substring > +--------+------------+ > | field1 | rDate | > +--------+------------+ > | 1 | 2002-03-01 | > | 2 | 2002-03-03 | > | 3 | 2002-03-05 | > | 4 | 2002-03-07 | > | 5 | 2002-03-11 | > +--------+------------+ > > mysql> select substring_index(rDate, "-", -1) as Day > -> from tblDate1 > -> order by Day; Thanks, but as I understand it this should not be needed as it is a regular date column and mysql should sort it for me right? - -- Nick Wilson // www.explodingnet.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE819tsHpvrrTa6L5oRAkUjAJ0WsLUYpOkKmWAwvn08m8ewQ6cgMQCcDxoq iOgEUaj2XvG3trF/nWqQXt4= =Uh1r -----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