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

Last updated on SEPTEMBER 07, 2023

Applies to:

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

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