- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 07-24-2023 07:19 AM
(666 views)
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;