Categories
- All Categories
- 4 Oracle Analytics Sharing Center
- 10 Oracle Analytics Lounge
- 189 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.4K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 65 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to filter Scheduled Ship Date based on Pacific Time Zone (PST/PDT) in OTBI Reports.
I have an OTBI report that retrieves a list of orders with missed scheduled ship dates. The filtering criteria for the report is set as "Fulfillment Lines - Scheduling Details"."Schedule Ship Date Fline" < (current_date), and it's filtering based on the UTC timezone.
Is there a way to modify this report to filter results based on the specified criteria but in Pacific Time (PDT/PST) instead of UTC?
Answers
-
Hi Dharma
Database timezone in UTC hence data is filtering in UTC format.
Database timezone cannot be changed.
Thanks & Regards
Rajasekhar
0 -
Hi Dharma
Database timezone in UTC hence data is filtering in UTC format.
Database timezone cannot be changed.
Thanks & Regards
Rajasekhar
0 -
Hi Dharma
Database timezone in UTC hence data is filtering in UTC format.
Database timezone cannot be changed.
Thanks & Regards
Rajasekhar
0