SELECT STR_TO_DATE(buy_datetime,'%a %b %d %H:%i:%S CST %Y') ,buy_datetime
from omoney_buy_info LIMIT 2
返回结果：
2010-01-30 10:40:50 Sat Jan 30 10:40:50 CST 2010
2010-01-30 10:41:59 Sat Jan 30 10:41:59 CST 2010
mysql 时间转换
SELECT STR_TO_DATE(buy_datetime,'%a %b %d %H:%i:%S CST %Y') ,buy_datetime
from omoney_buy_info LIMIT 2
返回结果：
2010-01-30 10:40:50 Sat Jan 30 10:40:50 CST 2010
2010-01-30 10:41:59 Sat Jan 30 10:41:59 CST 2010
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
