SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01874: time zone hour must be between -15 and 15

Rajneesh S-OracleJul 24 2020 — edited Jul 28 2020

Hello Experts,

I am getting below error:

INSERT INTO ABC

(

ID ,

CREATED_BY ,

CREATION_DATE ,

LAST_UPDATED_BY ,

LAST_UPDATED_DATE

)

SELECT

DEFAULT_A.ID ,

DEFAULT_A.CREATEDBY ,

TO_TIMESTAMP_TZ(DEFAULT_A.CREATIONDATE,'YYYY-MM-DD"T"HH24:MI:SS.FF3TZH:TZM') ,

DEFAULT_A.LASTUPDATEDBY ,

TO_TIMESTAMP_TZ(DEFAULT_A.LASTUPDATEDDATE,'YYYY-MM-DD"T"HH24:MI:SS.FF3TZH:TZM')

FROM

XYZ DEFAULT_A

, Error Msg = ORA-12801: error signaled in parallel query server P001

ORA-01874: time zone hour must be between -15 and 15

Data in file which I am trying to load is:

id,createdBy,creationDate,lastUpdatedBy,lastUpdatedDate

6101,10,2016-12-22T08:26:50.894223+01:00,2,2016-12-29T11:58:48.866+01:00

Thanks,

Rajneesh

This post has been answered by mathguy on Jul 24 2020

Jump to Answer

Added on Jul 24 2020

9 comments

1,796 views