My Oracle Support Banner

SOA 11g: XPATH 2.0 format-datetime() function Does Not Provide Millisecond Information When Requested In Format (Doc ID 1353031.1)

Last updated on APRIL 23, 2019

Applies to:

Oracle(R) BPEL Process Manager 10g - Version 10.1.2.2 and later
Information in this document applies to any platform.

Goal

There is a requirement to use the xp20:current-dateTime() function in ASSIGN activity together with a  DataBase Adapter to update specific DB column (Timestamp type only) with fractions of a second.

However there is no obvious methodology available to update the TimeStamp with 'fractions' of a second, for example:

Current result :  28-JUL-11 05.03.02.000000000 PM
Expected result: 28-JUL-11 05.03.02.128480000 PM

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!


In this Document
Goal
Solution
References

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