BookmarkSubscribeRSS Feed
agesser
Fluorite | Level 6

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!

1 REPLY 1
SASKiwi
PROC Star

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;