Postgres 12

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version

PostgreSQL 12.17 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-20), 64-bit

SELECT 1

create table user_record  (info jsonb);
insert into user_record values('{"someId": "XXFUN0123XX", "age": 43, "updatedAt": "2017-02-18 00:00:00"}')

CREATE TABLE

INSERT 0 1

select (info ->> 'updatedAt')::timestamp from user_record

timestamp

2017-02-18 00:00:00

SELECT 1

update user_record
set info=jsonb_set(info,'{updatedAt}',to_jsonb(to_char((info ->> 'updatedAt')::timestamp,'YYYY-MM-DD"T"HH24:MI:SS+02:00')))

UPDATE 1

select * from user_record

info

{"age": 43, "someId": "XXFUN0123XX", "updatedAt": "2017-02-18T00:00:00+02:00"}

SELECT 1

select info ->> 'updatedAt' from user_record

?column?

2017-02-18T00:00:00+02:00

SELECT 1