SOA 11g: XPATH 2.0 format-datetime() function Does Not Provide Millisecond Information When Requested In Format
Last updated on OCTOBER 18, 2016
Applies to:Oracle(R) BPEL Process Manager - Version: 126.96.36.199.0 to 188.8.131.52.0 - Release: 11gR1 to 11gR1
Information in this document applies to any platform.
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
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