Categories
- All Categories
- 143 Oracle Analytics News
- 27 Oracle Analytics Videos
- 14.7K Oracle Analytics Forums
- 5.7K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 54 Oracle Analytics Trainings
- 12 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Excel & CSV Export Date to Use the Correct Time Zone
Neil M 1
Rank 1 - Community Starter
Currently when users export data in Excel or CSV format (i.e. unformatted), dates are exported in raw format and converted to UTC time zone (refer the note at Analysis and Report Limits (oracle.com)).
This approach makes this data of no or limited value to most businesses and users. The time zone in which businesses operate is their reality. The current approach only meets the needs for the relatively small user base that operate in the UTC time zone.
The proposal is that unformatted date/time fields are exported with the correct time zone, i.e. the time zone is not converted to UTC, or the UTC time zone is converted to the relevant time zone (if the raw data is actually stored in UTC format and converted as purported).
Tagged:
7