apache or mysql time
hey all
on my ubuntu apache/mysql server, time is running with 6 houres of difference... like my server is living in another timezone... i use a ntp-server to correct time and when i do 'date' i see the correct time... when i insert queries with timestamps into the databank, i have 6 houres of difference... someone an idea how to fix this? is there somewhere else living a timezone? thx! |
First of all, NTP will set the correct date and time, but you'll need to configure your local timezone too.
Secondly, the difference of exactly 6 hours isn't due perhaps to the fact that MySql uses UTC standard times by default, for instance? In other words, what is the time difference between your zone and the UTC zone? Furthermore, have you checked out the MySql manual on Time zone settings? http://dev.mysql.com/doc/refman/5.0/...e-support.html ...is taken from the manual of MySql 5. I suppose other versions of MySql use similar time zone features. |
hey tim! thx voor de reply! check ik zeker uit! ;)
does someone knows how i can change the timezone without using the base-setup? thx! |
You're welcome, rubella.
On my RH8 box, I click with right mouse button on the date/time in the Gnome panel. Then I select "adjust date & time" from the context menu that appears. After supplying the root password, I can change the date, time, whether or not NTP is to be used as well as the timezone. The program Code:
system-config-date Maybe there's some graphical config for that in your menu too. Personnally, I haven't worked with Debian yet, so I can't provide more practical help. |
All times are GMT -5. The time now is 09:06 PM. |