VI 10.8, AML 8.3 ORACLE - how to deal with Timestamp with Time Zone values

agesser — Mon, 24 Jul 2023 11:19:04 GMT

hi all,
VI 10.8, AML 8.3 ORACLE

our date fields are defined as Timestamp with Time Zone in Oracle and VI.
The problem is that VI (AML) trying to "help" us and change the date 1 hour ahead or behind depends if this is Daylight Saving Time now or not.

example:

15 Jan 2015 00:00:00 in Oracle
shows as 14 Jan 2015 23:00:00 in VI

who has the same problem(Actually all used Oracle and timestamp with time zone fields should have this)
and how we can avoid this?

Thanks!

Re: VI 10.8, AML 8.3 ORACLE - how to deal with Timestamp with Time Zone values

SASKiwi — Wed, 26 Jul 2023 04:47:38 GMT

Perhaps reviewing SAS's time zone doc and settings might be helpful.

Run this to see what your TIMEZONE setting is:

proc options option = timezone;
run;

topic Re: VI 10.8, AML 8.3 ORACLE - how to deal with Timestamp with Time Zone values in Fraud, AML and Security Intelligence

VI 10.8, AML 8.3 ORACLE - how to deal with Timestamp with Time Zone values

Re: VI 10.8, AML 8.3 ORACLE - how to deal with Timestamp with Time Zone values