把时间和周几不同步的两个字段修改过来？

update dispatch_delivery_note  no 

set no.delivery_week= to_char(no.delivery_date,'D')-1

where no.delivery_week <> to_char(no.delivery_date,'D')-1