DATE_FORMAT "YYYY" Expression Changes Date to the Following Year
(Doc ID 2610989.1)
Last updated on NOVEMBER 15, 2022
Applies to:
Oracle TBE Reporting Cloud Service - Version 19A and laterInformation in this document applies to any platform.
Symptoms
When using the DATE_FORMAT expression operator along with a capital "Y" in the year format (for example, "Y", "YY", or "YYYY"), the expression provides a date that is one year later than expected.
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 |
Cause |
Solution |
References |