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 OCTOBER 13, 2021

Applies to:

Oracle(R) BPEL Process Manager 10g - Version and later
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


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

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