[BlueOnyx:23062] Re: Time difference

[Michael Stauber]

Hi Colin,

> I wonder if anybody can help with a weird time problem?
> 
> Customer has a webpage which writes to a MySQL database (for employee clocking on and off).
> 
> This has been working fine for a couple of years and now they are seeing  a18- 20 minute difference between the time when the employee clocks in (showing on web page) and the time recorded on the database!
> Server is not under any strain -- time zone is correct.

Twenty minutes is also an odd time-delta. If it was in full hours I
might suspect that perhaps PHP or the server itself is operating on the
wrong time zone. But 20 minutes? That's really odd.

The question here is: What generates the time stamps? Are these MySQL
time stamps or are they generated by PHP or another application and are
then inserted into MySQL as is?

If they're MySQL time stamps, then I'd suggest to restart MySQLd. Maybe
it's internal clock is out of whack with the server time and a restart
of MySQLd will fix that.

If it doesn't, then you'd need to find out what actually generates the
time stamps, because that's where the problem most likely comes from.

-- 
With best regards

Michael Stauber