New Oracle 21c Timestamp conversion issue
Software is working since a long time against Oracle 19c an older versions.
I installed Oracle 21c DB Server last week. Still use Oracle 19c Client workstation, after matching timezone files.
Since using Oracle 21c Db Server, get an ora-01878 issue when using simple select statement.
Would like to know if there's a workaround/patch/configuration to overcome issue.
Test Case :
create table jobs(
job varchar2(10) not null,
modification_datetime timestamp(0) with time zone default systimestamp at time zone 'utc' not null
);
--
alter table jobs add constraint pk_jobs primary key (job);
--
INSERT INTO jobs (job, modification_datetime)
VALUES ('JOB1', TO_TIMESTAMP_TZ('2022/03/07 7:14:52.00 PM +00:00','YYYY/MM/DD fmHH12fm:MI:SS.FF AM TZH:TZM'));