56,678
社区成员
发帖
与我相关
我的任务
分享
select STR_TO_DATE('5/27/2010 8:04:52 PM', '%m/%d/%Y %r')
mysql> show variables like 'datetime_format';
+-----------------+-------------------+
| Variable_name | Value |
+-----------------+-------------------+
| datetime_format | %Y-%m-%d %H:%i:%s |
+-----------------+-------------------+
1 row in set (0.00 sec)
mysql>