Time is one hour off
Time is one hour off
Time on machine running timetrex is correct but when punch in/out its one hour ahead.
I'm not sure, does Asia/Jerusalem timezone recognize daylight saving time?
If so, your MySQL timezone database may be out of date, or incorrect. You may want to upgrade it, instructions to do so are here:
http://forums.timetrex.com/viewtopic.php?t=40
If so, your MySQL timezone database may be out of date, or incorrect. You may want to upgrade it, instructions to do so are here:
http://forums.timetrex.com/viewtopic.php?t=40
I dont know what you mean by recognize daylight saving time.
I downloaded the latest timezone support as described in this post
http://forums.timetrex.com/viewtopic.php?t=40
It didnt do any change.
our timezone is GMT +2 which should be the same as Jerusalem.
any other suggestions?
I downloaded the latest timezone support as described in this post
http://forums.timetrex.com/viewtopic.php?t=40
It didnt do any change.
our timezone is GMT +2 which should be the same as Jerusalem.
any other suggestions?
If you change timezones, to GMT+0 for instance are the times correct if they happened in that timezone? Or are they off by an hour there too?
When using MySQL timezone issues are almost certainly caused by MySQL itself, all TimeTrex does is pass the timezone on to MySQL so it can do the conversions.
Try running these two queries at your MySQL console:
Is the time displayed correct?
When using MySQL timezone issues are almost certainly caused by MySQL itself, all TimeTrex does is pass the timezone on to MySQL so it can do the conversions.
Try running these two queries at your MySQL console:
Code: Select all
set session time_zone="Asia/Jerusalem";
select now();
Okay, so either you have selected the incorrect time zone, or your timezone database in MySQL is incorrect.
Have you downloaded the latest timezone tables described here:
http://forums.timetrex.com/viewtopic.php?t=40
If that doesn't fix the issue, then I would suggest finding a different timezone that better fits what you are looking for.
Have you downloaded the latest timezone tables described here:
http://forums.timetrex.com/viewtopic.php?t=40
If that doesn't fix the issue, then I would suggest finding a different timezone that better fits what you are looking for.
Try these commands are your MySQL console:
This is what it looks like on our test server here:
Does that return the expected time?select now();
set session time_zone="Etc/GMT+2";
select now();
This is what it looks like on our test server here:
mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2007-05-02 08:37:27 |
+---------------------+
1 row in set (0.03 sec)
mysql> set session time_zone="Etc/GMT+2";
Query OK, 0 rows affected (0.30 sec)
mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2007-05-02 13:37:30 |
+---------------------+
1 row in set (0.00 sec)
I'm not sure, I know in North America the daylight savings time was all changed, and that causes some timezones to adjust themselves by one hour on a specific date.
If you were using a timezone that observes DST, that is probably what happened. However Etc/GMT* timezones do not observer DST that I am aware of, so its hard to say.
If your servers timezone was changed, that could cause the problem as well.
If you go into a new MySQL console and run:
select now();
Is the time correct?
If you were using a timezone that observes DST, that is probably what happened. However Etc/GMT* timezones do not observer DST that I am aware of, so its hard to say.
If your servers timezone was changed, that could cause the problem as well.
If you go into a new MySQL console and run:
select now();
Is the time correct?
If I go to http://www.timezoneconverter.com (or http://www.timezoneconverter.com/cgi-bi ... /Jerusalem) and convert from GMT to Asia/Jerusalem I get GMT+3 and DST is in effect.
So that seems to explain the one hour difference that you all of a sudden started to see. Perhaps you don't observe DST where you are located? If thats the case then you will need to try a different timezone.
It all comes down to selecting the proper timezone that works for you, and since the timezones are all handled by MySQL, that determines what each timezone actually does.
So that seems to explain the one hour difference that you all of a sudden started to see. Perhaps you don't observe DST where you are located? If thats the case then you will need to try a different timezone.
It all comes down to selecting the proper timezone that works for you, and since the timezones are all handled by MySQL, that determines what each timezone actually does.