Time Zone Fix Support Thread

[gilby]

Gilby,

noticed this change from the beta and the new version

Beta Version

        // begin mod to set mysql timezone (gilby)
        if (getenv('TZ')) {
          @mysql_query("SET time_zone = '" . substr_replace(date("O"),":",-2,0) . "'", $this->link);
        }
        // end mod to set mysql timezone (gilby) 

New Version

        // begin mod to set mysql timezone (gilby)
          @mysql_query("SET time_zone = '" . substr_replace(date("O"),":",-2,0) . "'", $this->link);
        // end mod to set mysql timezone (gilby) 

Will this make any difference to how things work.

No it won't
The beta version just checked that you had indeed set the TZ variable, hopefully to your local time.

Removing that test still sets the mysql time to be the same as the php time.

I used the TZ variable as it is a backwardly supported way to set the php time.

In future you may in php5.3 set the php time a different way.
If you do then the mysql time will still be updated.