Hello All,
When we are trying to extract the OD System Log table on CMOD 10.1 every 15 mins based on TIME_STAMP, we are getting the results in GMT0 instead of EST. since SL tables are stored in UTC (GMT0) format, we could not get the expected results from our query after 7 PM EST which is next day 12:00 AM UTC. Below is my tweaked query (-5 HOURS) to fetch EST time zone but still it's not working.
SELECT CHAR(MSG_TEXT) FROM ARSSERVR.SL7721
WHERE TIME_STAMP >
(DAYS(CURRENT DATE) - DAYS('1970-01-01')) * 86400 +
MIDNIGHT_SECONDS(CURRENT TIME - 15 MINUTES -
CURRENT TIMEZONE - 5 HOURS)
AND MSG_NUM = 87
Any help or advice is greatly appreciated.
-Mani