When our serviceman are completing an outage on MobileTC in the field, the information shows up correctly in the Database. When the restore time and off time get to IDispatcher however, the restore time happens before the off time by an hour. Has anyone seen this before?
We are thinking Daylight savings maybe?
Is there a spot in CADDBM to check this or a command to run to make sure everything is synced up?
The time_zone_info table holds that kind of info: time_zone, universal time, daylight savings, etc. It used to be a database table, but I think now it is a View that gets populated from a bunch of other database objects/procedures/functions/stuff. So it takes a bit to drill down and actually modify something, but it's doable [with something like Toad or SQLDeveloper or similar]. Check your settings in there, and see if that sheds any light ...
Add a Comment
Please sign in on the right menu to comment.
If you do not have an account, please Join now.