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: to - Release: 11gR1 to 11gR1
Information in this document applies to any platform.


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 PM
Expected result: 28-JUL-11 PM


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