Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 53 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 293 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 116 Oracle Analytics and AI Trainings
- 21 Oracle Analytics and AI 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