Importing Date Only Attribute Does Not Consider User Time Zone Difference
Last updated on JANUARY 24, 2016
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms