How to Convert ESB Timestamp Field to Date and Time?

(Doc ID 755408.1)

Last updated on MARCH 09, 2012

Applies to:

Oracle ESB - Version: 10.1.3.1 to 10.1.3.5 - Release: AS10gR3 to
Information in this document applies to any platform.
***Checked for relevance on 09-Mar-2012***

Goal

How is the TIMESTAMP column from ESB_ACTIVITY table coded, and how to retrieve the DATE from this column ?


Solution

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 hundreds of Community platforms