主要介绍了MYSQL替换时间(年月日)字段,时分秒不变的实现方法，需要的朋友可以参考下

写法1： update sas_order_supply_month_pay set RECEIVE_TIME=REPLACE(RECEIVE_TIME,DATE_FORMAT(RECEIVE_TIME,'%Y-%m-%d'),(select PERIOD_END from sas_task_supply_month_pay_period where belong='1729' and CREATE_TIME like ' 17-07-12%')) where ORDER_CODE='PO20