Oracle Fusion Learning Cloud: BIP: How to Convert a Date from Database Time Zone (UTC) to Another Time Zone (Doc ID 2909238.1)

Last updated on MARCH 06, 2024

Applies to:

Oracle Fusion Learning Management Cloud Service - Version 11.13.22.07.0 and later
Information in this document applies to any platform.

Question:

Is it possible to convert a date in BI Publisher from the database time zone (UTC) to another time zone?

Incorrect date conversion can result in the following error: ORA-01878: specified field not found in datetime or interval

	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

Goal

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