I have ODBC tests that query SQL to be sure updates are constantly occuring in a GPS tracking system. The check is looking for data inserted during the last 20 minutes -- but the date recorded is Universal Time. Therefore, unless I actively change a value I'm using for date math (in our summer it would need to be 4:40, in our winter it would need to be 5:40), the test will test data during the last 1:20 in the winter.
I'd like to either enable two different tests only during their respective half of the year -- but do so automatically -- or be able to use some variable in the SQL query itself that will cull the time difference from the system offset. Good grief. This one's tough.
If the test settings were machine-editable somewhere I'd just edit the setting programmatically.