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;

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

Discussion stats
  • 1 reply
  • 970 views
  • 0 likes
  • 2 in conversation