My Oracle Support Banner

Function Current-dateTime Is Not Returning Same Number Of Digits For All Timestamp Values (Doc ID 2725693.1)

Last updated on NOVEMBER 06, 2020

Applies to:

Oracle Integration-OIC - Version 18.2.5 and later
Information in this document applies to any platform.

Symptoms

On : NA version, MICC Transfer to TSC

ACTUAL BEHAVIOR
---------------
Current-dateTime function is not showing 3 digit microsecond values same format all time. 

For eg:
sometimes it returns YYYY-MM-DDT24:59:59.123Z,
sometimes it returns YYYY-MM-DDT24:59:59.12Z

In the above timestamp format, last milliseconds value comes either 2 digit or 3 digit and it's not consistent.

EXPECTED BEHAVIOR
-----------------------
Format of current-dateTime function should be consistent.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Call fn:current-dateTime() and note the value is not consistent for the microsecond value.
 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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