SELECT & UPDATE shift_agreement.valid_from
Stable TMS_fleet update Helsingin Matkapalvelukeskus agreement start dates (https://app.clickup.com/t/86bymeppf)
SELECT index, org_uuid, company_uuid, valid_from, deleted_state FROM shift_agreement WHERE org_uuid = '1dfccc44-09c1-4e69-8554-3000cd2743f3' AND valid_from = '2024-05-01 00:00:00' AND deleted_state = 0;
UPDATE shift_agreement
SET valid_from = '2024-04-30 00:00:00'
WHERE org_uuid = '1dfccc44-09c1-4e69-8554-3000cd2743f3' AND valid_from = '2024-05-01 00:00:00' AND deleted_state = 0 RETURNING index, org_uuid, company_uuid, valid_from, deleted_state, duration_minutes;