My Oracle Support Banner

OTAC/TEE: How To Convert a Long Date into Standard Date Format (Doc ID 2113427.1)

Last updated on OCTOBER 17, 2019

Applies to:

Oracle Taleo Platform Cloud Service - Reporting for OBI - Version 17.0 and later
Information in this document applies to any platform.



I have a report that contains a field that has the date in the below format.  Is there a way to convert this to a standard date format in OBI?

  • Month DD, YYYY HH:MM AM     -- January 01, 2011 12:00 AM
  • Month DD, YYYY HH:MM PM     -- January 01, 2011 12:00 PM
  • DD Month YYYY HH24:MM       -- 01 January 2011 15:00




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.