SELECT date_format( '2008-01-22', '%d-%m-%Y' ) ;

------解决方案--------------------
....

SQL code
SELECT date_format( '2008-01-22 03:54:00', '%d-%b-%Y %h:%i %p' ) ;

------解决方案--------------------
SQL code

select date_format( adpostday, '%d-%b-%Y %h:%i %p' ) from adrecord where Id=1;
+-----------------------------------------------+
| date_format( adpostday, '%d-%b-%Y %h:%i %p' ) |
+-----------------------------------------------+
| 05-Dec-2007 12:00 AM                          | 
+-----------------------------------------------+
1 row in set (0.00 sec)