Just a matter of preferences... I just prefer to use explicit functions rather than using the date format strings MySQL :: MySQL 5.0 Reference Manual :: 10.6 Date and Time Functions covers all the date time functions you could ever need in MySQL.