Date/Timestamp Parameter Values Retrieved Using Logical SQL Query Shows Incorrect Date By -1 Day
(Doc ID 2984083.1)
Last updated on JUNE 06, 2024
Applies to:
Oracle Analytics Server - Version 2023 and later
Information in this document applies to any platform.
Symptoms
- Create Data Visualization Workbook
- Create a Date/Timestamp Type parameter
- Edit created parameter, update Logical SQL Query in Possible Values and Initial Values
- Select Dashboard Filter in the Workbook
- Add Date type parameter as Dashboard Filter in Workbook
- Set initial value to "10/31/2023" as an example
- Now check the filter, shows date -1 => "10/30/2023"
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
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.