My Oracle Support Banner

Is There A Way To Change The Timestamp Filter Drop Down Format To 24hr Format. (Doc ID 1901956.1)

Last updated on JUNE 22, 2018

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.1 and later
Information in this document applies to any platform.

Goal

 

Is there a way to set the date and time format for a column filter to 24 hr format in InstanceConfig or somewhere else?


eg. The time part of the datetime filter drop down is currently displayed as 12:00:00 AM
 

Out of the box, one can set the datetime default format for a column..

For example:-

Using Usage Tracking – Starttime (datetime)

We can change the datetime column format to 24 hr (MM/dd/yy HH:mm:ss)

However, when we try to specify the filter, the datetime format is still using the default 12hr (AM/PM) 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!


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