SUPPORT / SAMPLES & SAS NOTES
 

Support

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)

DetailsHotfixAboutRate It

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 FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Visual InvestigatorLinux for x6410.7Viya
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.