MySQL日期格式化

UPDATE `wxinfo_temphwl`  set date=DATE_FORMAT(createDate,'%Y-%m-%d');

createDate="2017-03-30 02:00:00"

格式化后date结果："2017-03-30"

 

參考http://www.cnblogs.com/duhuo/p/5650876.html

 

-----------------------------------------------------------------------------