update pos_t_payflow
set oper_date='2022-10-26'+right(convert(varchar,oper_date,120),9)
where convert(char(10),oper_date,120)>'2022-10-26' and approve_flag<>'1'
update pos_t_saleflow
set oper_date='2022-10-26'+right(convert(varchar,oper_date,120),9)
where convert(char(10),oper_date,120)>'2022-10-26' and approve_flag<>'1'
delete from sys_t_operator_log where convert(char(10),oper_date,120)>'2022-10-26'
- 上一篇:没有了!
- 下一篇:没有了!