Information: Forum is in read-only mode
For details and other support options see https://www.adiscon.com/news/support-forum-set-to-read-only-mode/

Problem with timezone of displayed timestamp

Support, Questions and Discussions on MonitorWare Console

Moderator: alorbach

Google Ads


Problem with timezone of displayed timestamp

Postby dfg » Mon Dec 13, 2004 6:01 pm

I just noticed a new problem: in console the timestamps of the messages appear in some unknown timezone instead of the local timezone (CST) - the displayed values are 6 hours behind. I found a Time Zone dialog under Options - I selected Central Time and hit Close (there is not an OK button), but it doesn't seem to affect the displayed data.

How do I change the displayed timezone?

Here is the version information for our setup:

Code: Select all
MySQL             4.1.7
ODBC driver       3.51.10
Console           2.1.1789.29951
Windows           2000 Pro (Service Pack 4)


Here is an images showing the timestamp in the database:
http://www.dgkp.net/forum/prob2.jpg

Here is an images showing the timestamp in console:
http://www.dgkp.net/forum/prob1.jpg

Thanks in advance for your help.
dfg
dfg
 

anyone?

Postby dfg » Mon Dec 27, 2004 2:58 pm

Does anyone know what the Time Zone dialog box is supposed to do?

Does anyone know what the default time zone for the event views should be?

Any help would be appreciated. In the mean time I will probably reinstall the software and see if it was any of the "fix" binaries that I received (for other problems) causing my issues...

Thanks,
dfg
dfg
 

fixed?

Postby dfg » Thu Dec 30, 2004 3:18 pm

I think I figured it out...

The software seems to assume that all date/time values in the database are in GMT and applies the user's timezone offset to those values....my database values are in CST and my user's timezone was CST and the resulting displayed date/time values were 6 hours off.

The solution was to set the user's timezone to GMT (no offset) which effectively displayed the correct database values with no offset.

Not sure if my assumptions are correct but my user's now see the correct timestamps...

dfg
dfg
 

Postby wrehman » Tue Jan 04, 2005 10:08 am

Hello,

You are right. MonitorWare Console assumes that the values in the database are in UTC. So, if your values *are* in UTC in your database, then you should select correct timezone of your current user so that it can add that offset to give you the correct value of time. However, if your values in the database are *not* in UTC (rather are in local time format), then you should select a timezone with 0 offset. I hope this helps

Best Regards
Wajih-ur-Rehman
Adiscon
wrehman
Adiscon Support
 
Posts: 75
Joined: Tue Mar 18, 2003 9:30 am

Postby wrehman » Tue Jan 04, 2005 10:09 am

Hello,

Further description of the same thing is given in this FAQ

http://www.mwconsole.com/en/faq/Wrong-D ... Values.php

regards
Wajih
Adiscon
wrehman
Adiscon Support
 
Posts: 75
Joined: Tue Mar 18, 2003 9:30 am

thanks

Postby dfg » Tue Jan 04, 2005 5:26 pm

Thanks for the verification.

I thought I had looked through the FAQ section but obvioulsy I didn't or I missed it when I did. I'll make sure to check it and search the forums next time...

Thanks,
dfg
dfg
 

Google Ads



Return to MonitorWare Console

Who is online

Users browsing this forum: No registered users and 0 guests

cron