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

Last updated on OCTOBER 18, 2016

Applies to:

Oracle(R) BPEL Process Manager - Version: 11.1.1.1.0 to 11.1.1.5.0 - Release: 11gR1 to 11gR1
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

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