Database and Application Timezone

[Adamhumbug]

I have an application that records the time that someone last logs in using CURRENT_TIMESTAMP

The time set in the database is 1 hour ahead of the actual time suggesting that the time zones are out.  I am in the UK.

I have a function that works out the time  since their last log on and this is reporting 2 hours ago.

Any advice on time zones for the data base and application?

[Barand]

What does this query give?

SELECT @@session.time_zone as tzone, TIMEDIFF(NOW(), UTC_TIMESTAMP) as tdiff;

As a fellow Brit I would expect to see ...

+--------+----------+
| tzone  | tdiff    |
+--------+----------+
| SYSTEM | 01:00:00 |
+--------+----------+

... meaning it is using your servers system time settings and currently British Summer Time

[Adamhumbug]

tzone tdiff

SYSTEM 02:00:00

[Barand]

Check your server's date/time settings. Looks like your default timezone is "Europe/Paris" or somewhere along that longitude.

If you don't have control over the server settings then check your cPanel options for timezone settings.

Failing that, set a default in your db connection procedure.