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: [email protected] [mailto:[email protected]] 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 <[email protected]> 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 [email protected] http://mail.blueonyx.it/mailman/listinfo/blueonyx
_______________________________________________ Blueonyx mailing list [email protected] http://mail.blueonyx.it/mailman/listinfo/blueonyx
