My Oracle Support Banner

Created Date/Time Field Only Showing Date- Please advise of workarounds as we want to show Date and time for this field (Doc ID 2177341.1)

Last updated on FEBRUARY 19, 2018

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Goal

We have a requirement to show the system field, CreateDate to show the date/time for a custom object called Touchpoint Notes.
We have added the field to the UI but it's only showing the date but not the time.
We checked in the OOTB objects, they are the same way. When we created a SQL report in BI, we can see the field is storing as date/time.
We need to know how we can have the date/time show up for that field. Please advise as this is a critical requirement for the client.
 

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.