My Oracle Support Banner

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 12.2.1.4.0 and later
Oracle Forms for OCI - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Goal

NOTE: The sample program in this article is provided for educational purposes only and is NOT supported by Oracle Support Services. It has been tested internally and works as documented. Oracle can not guarantee that it will work in all possible configurations, so be sure to test it thoroughly in your test environment before deploying it.

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

ENO EDATE EDATE_TS
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.

Solution

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
Solution


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