On 11/11/2011 16:29, Curtis Maurand wrote:
mysql> select date_format(now(),'%m-%d%-%y %h:%i:%s') AS time; +-------------------+ | time | +-------------------+ | 11-11-11 11:11:11 | +-------------------+ 1 row in set (0.00 sec)
Actually, it should be select date_format(now(),'%y-%m%-%d %h:%i:%s') :-) Mark -- Sent from my Babbage Difference Engine http://mark.goodge.co.uk http://www.ratemysupermarket.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
