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


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

2 20-Sep-21 08-AUG-17 AM +05:30
2 20-Sep-21 20-SEP-21 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

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