Problem Note 68469: The displayed time in SAS® Visual Investigator is incorrect if the time value is related to an Oracle field with a TIMESTAMP WITH TIME ZONE data type
 |  |  |  |  |
By design, when you view data in the investigation interface, any time values are converted to match the client time. This change is not an issue unless your database type is Oracle and an Oracle field is of the data type TIMESTAMP WITH TIME ZONE. Then, the UI displays an incorrect timestamp value instead of the expected client time.
This problem does not affect either TIMESTAMP fields or TIMESTAMP WITH LOCAL TIME ZONE fields from Oracle databases.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Investigator | Linux for x64 | 10.7 | Viya | ||
Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdatesAn update for this issue is available for SAS Visual Investigator 10.7. For instructions on how to access and apply these software updates, see the documentation links at the top of
https://tshf.sas.com/techsup/download/hotfix/HF2/Viya_VI_10_7_home.html#68469| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2021-10-29 13:22:46 |
| Date Created: | 2021-10-01 16:56:22 |