1. Using the Oracle Mapper with Oracle Integration Generation 2
  2. Troubleshoot the Mapper
  3. Current-dateTime Function Does Not Return the Same Number of Digits for All Timestamp Values

Current-dateTime Function Does Not Return the Same Number of Digits for All Timestamp Values

The Current-dateTime function in the mapper does not return the same number of digits for all timestamp values.

For example, the three digit microsecond value is not the same format each time.

YYYY-MM-DDT24:59:59.123Z
YYYY-MM-DDT24:59:59.12Z
If you want the specific format value to be consistent, use the xp20:format-dateTime function to format the timestamp. For example:
xp20:format-dateTime (fn:current-dateTime(), "[Y0001]-[M01]-[D01]T[H01]:[m01]:[s01].[f001]" )
This function returns the following format:
2020-10-30T21:58:15.172Z