On Fri, 2011-11-11 at 16:38 +0000, Mark Goodge wrote: > 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 >
*Actually*, it wouldn't make any difference what-so-ever which way round the tokens are!!! (for this case anyway) ----------------------------- Registered Office: 15 Stukeley Street, London WC2B 5LT, England. Registered in England number 1421223 This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. Please note that the information provided in this e-mail is in any case not legally binding; all committing statements require legally binding signatures. http://www.inflightproductions.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org