SQL记录

select id, collecting_days, published_at from tasks where id=753; 
update tasks set published_at ='2023-11-07 09:07:01' where id=753;
update tasks set published_at ='2023-11-03 09:08:01' where id=753; 

select id, name, collecting_complete_at, choosing_days from tasks where id=410;
update tasks set collecting_complete_at='2021-09-29 16:41:01' where id=436; 

select task_id, process_instance_id from task_result_proof where task_id=430;
select PROCESS_INSTANCE_ID_, DUEDATE_ from ACT_RU_TIMER_JOB where PROCESS_INSTANCE_ID_ = '23015233-200f-11ec-9423-0242ac110003';
update ACT_RU_TIMER_JOB set DUEDATE_ ='2021-11-21 13:40:01.000' where PROCESS_INSTANCE_ID_ = '46dxxxxxxx';
update ACT_RU_TIMER_JOB set DUEDATE_ ='2021-11-21 13:40:01' where PROCESS_INSTANCE_ID_ in (select process_instance_id from task_result_proof where task_id=133); 

 select id, name, publicity_complete_at, signing_days from tasks where id=436;
update tasks set publicity_complete_at = '2021-09-22 11:11:01' where id=436; 

select id,name, signing_complete_at, paying_days from tasks where id=399;
update tasks set signing_complete_at='2021-09-29 16:37:01' where id=436;