MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table ratingperiods
(
    Id              /* binary(16) */ INT      not null            primary key,
    EndDate         date                      not null,
    Settings        json                      null
);
INSERT INTO ratingperiods SELECT 1, CURRENT_DATE, '{"ProductRating": {}} ';
SELECT Id, EndDate, CAST(Settings AS CHAR) Settings FROM ratingperiods;

Records: 1  Duplicates: 0  Warnings: 0




Id
EndDate
Settings


1
2024-08-07
{"ProductRating": {}}


UPDATE ratingperiods
SET Settings = JSON_SET(Settings, 
                        '$.ProductRating.EndOfAppealPeriod',
                        DATE_FORMAT(EndDate + INTERVAL '4 9' DAY_HOUR, '%Y-%m-%dT%H:%i:%sZ'));

Rows matched: 1  Changed: 1  Warnings: 0


SELECT Id, EndDate, CAST(Settings AS CHAR) Settings FROM ratingperiods;


Id
EndDate
Settings


1
2024-08-07
{"ProductRating": {"EndOfAppealPeriod": "2024-08-11T09:00:00Z"}}