My Oracle Support Banner

ORA-01891: Datetime/Interval internal Error for AERS Users Querying in SQL when Setting User Timezone To EST5EDT (Doc ID 753656.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Adverse Event Reporting System - Version 4.6.1 and later
Information in this document applies to any platform.


Users with a timezone of EST5EDT in AERS receive the following error message when attempting to
run a SQL query as this same user in SQL Navigator or SQL plus: ORA-01891: Datetime/Interval internal error

Queries run successfully if the timezone is changed to a number (e.g. -4.00)

To Reproduce:

SQL> select * from aers1.ae_cases;



ORA-01891: Datetime/Interval internal error

no rows selected




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.