mysql日期类函数

 

SELECT UNIX_TIMESTAMP(NOW())  把日期转化秒

 

 

DATE_FORMAT(CREATE_DATE,'%Y-%m-%d') datetime转string

date_format(#{date,jdbcType=TIMESTAMP},'%Y-%m-%d')

SELECT DATE_FORMAT(CREATE_DATE,'%Y-%m-%d') FROM hk_lovego_hotsearch 

 

 

 STR_TO_DATE('2017-04-18 17:48','%Y-%m-%d %H:%i'); 固定的string转date

 

 

DATE_ADD(d.CREATE_DATE,INTERVAL - 1 DAY)日期减去一天 day可变为年等

 

UPDATE lovego_market_lock_point_detail d 

JOIN lovego.hk_lovego_users u ON d.USER_ID = u.ID

SET d.CREATE_DATE = DATE_ADD(d.CREATE_DATE,INTERVAL - 1 DAY)

WHERE u.LOGIN = '17688938954'

AND d.CREATE_DATE < STR_TO_DATE('2017-04-18 17:48','%Y-%m-%d %H:%i');