In case you all missed it.

[Curtis Maurand]

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)