我试过好像不行。 insert into aa (id,name,pid,val,tm,stm) values(9,'AS',8,'1','2012-09-05 21:48:20',date_format('2012-09-05 21:48:20','%p%h:%m:%s')); 我是这么写的,有啥毛病吗,还是建表的时候得指定一下格式呢??
mysql> insert into aa (id,name,pid,val,tm,stm) values(9,'AS',8,'1','2012-09-05 21:48:20',date_format('2012-09-05 21:48:20','%p%h:%m:%s')); Query OK, 1 row affected (0.00 sec)mysql> select * from aa; +------+------+------+------+---------------------+------------+ | id | name | pid | val | tm | stm | +------+------+------+------+---------------------+------------+ | 9 | AS | 8 | 1 | 2012-09-05 21:48:20 | PM09:09:20 | +------+------+------+------+---------------------+------------+ 1 row in set (0.00 sec) 能有啥问题?
+---------------------------------+
| DATE_FORMAT(now(),'%p%h:%i:%s') |
+---------------------------------+
| PM10:14:15 |
+---------------------------------+
insert into aa (id,name,pid,val,tm,stm) values(9,'AS',8,'1','2012-09-05 21:48:20',date_format('2012-09-05 21:48:20','%p%h:%m:%s'));
我是这么写的,有啥毛病吗,还是建表的时候得指定一下格式呢??
values(9,'AS',8,'1','2012-09-05 21:48:20',date_format('2012-09-05 21:48:20','%p%h:%m:%s'));
Query OK, 1 row affected (0.00 sec)mysql> select * from aa;
+------+------+------+------+---------------------+------------+
| id | name | pid | val | tm | stm |
+------+------+------+------+---------------------+------------+
| 9 | AS | 8 | 1 | 2012-09-05 21:48:20 | PM09:09:20 |
+------+------+------+------+---------------------+------------+
1 row in set (0.00 sec)
能有啥问题?