Importing Date Only Attribute Does Not Consider User Time Zone Difference
(Doc ID 2035985.1)
Last updated on FEBRUARY 19, 2019
Applies to:Oracle Agile Product Collaboration - Version 18.104.22.168 to 22.214.171.124 [Release 9.3]
Information in this document applies to any platform.
Importing Date attribute will be converted to GMT time zone automatically and does not consider user time zone preference. Even when the user time zone is set to (GMT+09:00) Japan Standard Time (Osaka, Sapporo, Tokyo), import results shows that the date is converted to -9 hours and the imported date is being set to date before.
Importing Date attribute will consider user time zone preference
- On Java Client, set a Part subclass with Page Three Date attribute to active. Date Time Format is set to Date only.
- Login to Web Client on the user with the following preference:
Time Zone:(GMT+09:00) Japan Standard Time (Osaka, Sapporo, Tokyo)
- Import excel file with the following date attribute.
Number | Date
P00116 | 2015/06/01
- Go the Part and check the Date attribute.
Date is set to 2015/05/31
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