[BlueOnyx:09083] Re: mysql timestamp

[Steffan]

Oke thanxs

 

Im in contact with the client

Don't know what he is doing

When I look in phpmyadmin I see the right settings in the table

So looks like he is messing up his code and is blaming me J

 

 

Van: blueonyx-bounces at mail.blueonyx.it
[mailto:blueonyx-bounces at mail.blueonyx.it] Namens Charles Bowman
Verzonden: maandag 21 november 2011 10:42
Aan: BlueOnyx General Mailing List
Onderwerp: [BlueOnyx:09081] Re: mysql timestamp

 

If you login to the GUI , them go to: system Settings -> Time

Is the date & time correct?

Is the value for "Time Zone" correct?

Do you have an "NTP Server Address" defined and is it in your time zone?

 

mySQL should take the time from the "system_time_zone" system variable.

 

So, unless you start mySQL manually setting the time on start-up, it should
use SYSTEM var.

In mySQL execute the following query: SELECT @@global.time_zone,
@@session.time_zone;

This should result in: "SYSTEM" | "SYSTEM"

Showing your time as coming from the system; so just update your timezone in
system Settings -> Time.

 

Cheers,

C

 

On 21 November 2011 09:03, Steffan <general at ziggo.nl> wrote:

Hello,

I have a server where mysql timestamp is 6 hour behind the server time
in the gui I change the zone safed it
changed it back saved it but did didns solve the problem

any idees

greats

Steffan

_______________________________________________
Blueonyx mailing list
Blueonyx at mail.blueonyx.it
http://mail.blueonyx.it/mailman/listinfo/blueonyx

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.blueonyx.it/pipermail/blueonyx/attachments/20111121/4a8e661f/attachment.html>