PegoraroF10 <[email protected]> writes: > Ok Tom but then you cannot go back and forth, like this ... > select to_timestamp(jsonb_build_object('mydate', > current_timestamp)->>'mydate', 'YYYY-MM-DD HH24:MI:SS');
> works on 11.7 but not on 12.3.
The advice I gave you was to stop using to_timestamp altogether.
That would work fine on any Postgres version.
regards, tom lane
