MYSQL時間修正
514 ワード
-- SELECT "2011-11-33" " 10:00:00" from plat_mt_history where batchId = 48793 LIMIT 0,100
-- SELECT CONCAT("2015-02-17 10:00:", right(DATE_FORMAT(sendTime, '%Y-%m-%d %k:%i:%s' ),2)) as from plat_mt_history where batchId = 48793 LIMIT 0,1000
UPDATE plat_mt_history set createTime =CONCAT("2015-02-17 10:00:", right(DATE_FORMAT(createTime, '%Y-%m-%d %k:%i:%s' ),2)) where batchId = 48793