mysql> select DATE_FORMAT( now(), '%m/%e/%Y %h:%i:%S %p');
+---------------------------------------------+
| DATE_FORMAT( now(), '%m/%e/%Y %h:%i:%S %p') |
+---------------------------------------------+
| 04/19/2006 03:07:50 PM |
+---------------------------------------------+
+---------------------------------------------+
| DATE_FORMAT( now(), '%m/%e/%Y %h:%i:%S %p') |
+---------------------------------------------+
| 04/19/2006 03:07:50 PM |
+---------------------------------------------+
INSERT INTO VEHICLE (DATE)
VALUES (DATE_FORMAT( '08/25/2005 04:05:38 下午', '%m/%e/%Y %h:%i:%S %p'));
不过老是运行不了,说什么前面的'08/25/2005 04:05:38 下午'有问题