Column With TIMESTAMP WITH TIMEZONE Is Converting As CHAR Instead Of DATE DataType
(Doc ID 2810428.1)
Last updated on APRIL 26, 2023
Applies to:Oracle Reports Developer - Version 18.104.22.168.0 and later
Oracle Forms for OCI - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
You have a Database column of datatype "TIMESTAMP WITH TIMEZONE" and would like to use the same column as DATE format in Oracle Reports.
Example: EMP table
|2||20-Sep-21||08-AUG-17 02.00.00.000000000 AM +05:30|
|2||20-Sep-21||20-SEP-21 07.33.00.400000000 PM +05:30|
Running the above table in the Reports data model/layout shows the DataType as "CHAR". So no Date Formatting masks can be applied to get the desired date format output in the layout.
Goal is to get the TIMESTAMP WITH TIMEZONE column as 'DD-MON-YYYY' format.
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