fn-bea:dateTime-to-string-with-format gives 2019 year for December 30 and 31 2018 with YYYY-MM-dd notation (Doc ID 2504487.1)

Last updated on AUGUST 16, 2024

Applies to:

Goal

Oracle Service Bus 12.2.1.1.0

We have used the following function to generate current date-time on OSB pipeline.
fn-bea:dateTime-to-string-with-format("YYYY-MM-dd'T'HH:mm:00",fn:current-dateTime())

This function worked fine though out the year of 2018 but only on 31st December 2018, this function returned a date-time as "current date-time + 1" year which was not expected.
I.e. instead of returning the year as 2018, it returned the year as 2019.

On 1st of January 2019 onward, the function again automatically started returning correct date-time.
So it seems that this function failed only for the day of 31st December 2018 and worked fine for all other days of the year.

Solution

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