Did you run the report and the query from the same machine? If they were different than its possible one of the machines that you either ran the report or the query from was not adjusted for DST.
Thanks Peter Lammey ESPN IT Client Architecture and Automation 860-766-4761 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of patrick zandi Sent: Tuesday, May 19, 2009 9:10 AM To: [email protected] Subject: reporting times - 1 hour question ** I have found a scenario where if you query the form (incident) ('1000000560' >= "5/19/2009 7:30:00 AM" AND '1000000560' <= "5/19/2009 9:00:00 AM") and it comes back with 4 tickets, however if you use the report function of the incident console you get back 2 the other 2 are not there, but if you change the query in the report console to 1 hour earlier ('1000000560' >= "5/19/2009 6:30:00 AM" AND '1000000560' <= "5/19/2009 9:00:00 AM") now you get 4 again. We have looked at the oracle server, time is correct We have looked at the ARS server, time is correct We have looked at the oracle Config -- it is set to the servers time. now here is a question, how is it the report portion finds the data after a minus of 1 hour and the data in the form is correct (time fields) and yet the usertool finds it at the correct time just fine? This does happen reguardless of the client, api source. anyone see this? ENV:: ars 7.1 -- patch 6 cmdb 7.1 patch 5 Solaris 10 - X64 Oracle 10.2.0.5 --on solaris 10 Everthing on UTC time (servers) -- Patrick Zandi _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ ________________________________ Please consider the environment before printing this e-mail. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
