PegoraroF10 <marcos(at)f10(dot)com(dot)br> 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