BookmarkSubscribeRSS Feed
agesser
Obsidian | Level 7

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;

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand in the Innovate Hub.

Watch Now →
Discussion stats
  • 1 reply
  • 1609 views
  • 0 likes
  • 2 in conversation