Time discrepancy in sql table versus console
lloo May 5, 2010 4:05 PMI am looking at my ticket details in the console and it is showing closed 5/5/10 2:36pm
I check in the im_incident_resolution table for same record and it is showing for im_creation_date of 5/5/10 9:41pm
So it looks like in the tables it's 7 hours and 5 minutes ahead of what it is showing in the console.
Please advise as we use a view from the sql table to generate excel reports from data in servicedesk.
I have version 7.2.6 thanks