Daylight savings time? Sent from my Verizon Wireless BlackBerry
-----Original Message----- From: patrick zandi <[email protected]> Date: Tue, 19 May 2009 09:09:35 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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
