mysql替换中文年月日

UPDATE `crawler_content` SET f_article_time = REPLACE(REPLACE( REPLACE(f_article_time,'日',''),'月','-'),'年','-')

UPDATE `crawler_content` SET f_article_time = DATE_FORMAT(f_article_time, '%Y-%m-%d %H:%i:%s' ) WHERE f_article_time !='' OR f_article_time!=NULL


UPDATE `keywords_content` SET articleTime = REPLACE(REPLACE( REPLACE(articleTime,'日',''),'月','-'),'年','-')

UPDATE `keywords_content` SET articleTime = DATE_FORMAT(articleTime, '%Y-%m-%d %H:%i:%s' )

SELECT  articleTime,

DATE_FORMAT(articleTime, '%Y-%m-%d %H:%i:%s' ) A FROM keywords_content;

UPDATE `crawler_content` SET f_article_time = REPLACE(REPLACE( REPLACE(f_article_time,'日',' '),'月','-'),'年','-')


SELECT * FROM crawler_content WHERE LENGTH(f_article_time)<17


UPDATE `crawler_content` SET f_article_time = DATE_FORMAT(f_article_time, '%Y-%m-%d %H:%i:%s' ) WHERE LENGTH(f_article_time)<17 AND f_article_time!=''




DELETE FROM crawler_content WHERE f_article_time LIKE '%May%'


UPDATE `t_hotcontents` SET publishTime = REPLACE(REPLACE( REPLACE(REPLACE(REPLACE(publishTime,'点',':'),'分',''),'日',' '),'月','-'),'年','-')
UPDATE `t_hotcontents` SET publishTime = DATE_FORMAT(publishTime, '%Y-%m-%d %H:%i:%s' )


SELECT * FROM crawler_content WHERE  f_article_time LIKE '%May%'


 id=15109


`test_insert2` LENGTH(f_article_time)=15
 SELECT SUBSTRING(f_article_time, 11,15) FROM crawler_content WHERE id=14372


UPDATE crawler_content SET f_article_time =  CONCAT(SUBSTRING(f_article_time, 1,10),' ',SUBSTRING(f_article_time, 11,15)) WHERE LENGTH(f_article_time)=15;

存储过程：

定时处理日期 每天处理一次

触发器 

：保存数据的时候触发