#更改发货单的到货时间距离目前还有15天
UPDATE parana_delivery_order SET arrival_date =DATE_FORMAT(DATE_SUB(NOW(),INTERVAL 15 DAY),'%Y-%m-%d') WHERE `code` IN('SO20220915000005001001','SO20220915000005001001');
#更改发货单的到货时间距离目前还有15天 零2分
UPDATE parana_delivery_order SET delivery_date = DATE_ADD(DATE_SUB(NOW(),INTERVAL 30 DAY),INTERVAL 2 DAY_MINUTE) WHERE `code` = 'SO20220916000003001001';
#更改需求单的创建时间
UPDATE parana_order SET createdAt ='2022-06-30 11:00:00' where code ='SO20220829000003';
sql语句中关于时间的查询、修改
最新推荐文章于 2023-12-12 15:59:24 发布