Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

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'));

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center