Format now()

mysql> SELECT DATE_FORMAT(now(),'%d - %T - %Y');
+-----------------------------------+
| DATE_FORMAT(now(),'%d - %T - %Y') |
+-----------------------------------+
| 01 - 00:55:10 - 2004              |
+-----------------------------------+

http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html

korrekt :-)

Eller måske

mysql> SELECT DATE_FORMAT(now(),'%e %M - %T - %Y');
+--------------------------------------+
| DATE_FORMAT(now(),'%e %M - %T - %Y') |
+--------------------------------------+
| 1 July - 00:57:31 - 2004            |
+--------------------------------------+

jaa, det var nu mest kommandoen/syntaksen jeg var ude efter... :-)