My Oracle Support Banner

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 JANUARY 23, 2020

Applies to:

Oracle Service Bus - Version 12.2.1.0.0 and later
Information in this document applies to any platform.

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

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
Goal
Solution
References


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