[JayWilliamson@su...]

We don't have sentinel yet so I have some reports and monitors written in Oracle pl/sql that select infomation from the G.I. tables. In those reports/monitors I use the (gmt - x hours) value which changes between gmt-5 and gmt-6 depending on if it is daylight savings time or not. Any ideas if G.I. stores the 'Server's time zone' either in the database or in some config file that I could make use of to populate my variable that holds the (gmt - x hours) value in my select statements? This would save me the time of creating a one-off solution to automate the DST change twice a year rather than having someone change the (gmt - 5 to gmt - 6). Thanks for any suggestions! Jay Williamson

[JayWilliamson@su...]

We don't have sentinel yet so I have some reports and monitors written in Oracle pl/sql that select infomation from the G.I. tables. In those reports/monitors I use the (gmt - x hours) value which changes between gmt-5 and gmt-6 depending on if it is daylight savings time or not. Any ideas if G.I. stores the 'Server's time zone' either in the database or in some config file that I could make use of to populate my variable that holds the (gmt - x hours) value in my select statements? This would save me the time of creating a one-off solution to automate the DST change twice a year rather than having someone change the (gmt - 5 to gmt - 6). Thanks for any suggestions! Jay Williamson

Ignore my inquiry - with a little research I was able to find a command on the Oracle database (SELECT dbtimezone FROM dual) that returns the current DST/UTC offset that I can use in my reports/monitors. Thanks anyway, Jay

[GuitarCrazyo]

Definitely change it back to standard time year-round. Most places at our latitude dont observe DST anyways in the Caribbean, Africa, Asia, and Australia.