Problem Note 68862: You encounter date and time issues in SAS® Visual Investigator when the Oracle time-zone setting is not set to UTC (Coordinated Universal Time)
 |  |  |  |  |
You can encounter issues in SAS Visual Investigator related to an incorrect date and time when you are using an Oracle database and the database time zone is not set to UTC (Coordinated Universal Time).
In this scenario, columns that use the TIMESTAMP WITH LOCAL TIME ZONE data type in Oracle are incorrectly mapped to datahub fields that are defined as the TIMESTAMP data type instead of the TIMESTAMP WITH TIME ZONE data type.
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 | ||
An 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#68862An 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#68862| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2022-02-09 13:37:42 |
| Date Created: | 2022-02-01 12:15:17 |