System Time

[LAUBi]

Heyho outa there,

i got a disgusting problem, the server time is [bleep] up...

all my mysql entries refer to the wrong time and so my homepage entries are displayed with a wrong time, i always have to recalculate the time

can anyone help me to change the server time?

Thanks

[openmp3]

Don't you think the server's time is GMT?

 

Maybe you can try php's date-default-timezone-set():

http://www.php.net/manual/en/function.date...imezone-set.php

 

O and maybe try asking more nicely next time, maybe people are more willing to help you.

[LAUBi]

hmk sorry,

no i don't think, without modifying anything about time the time is about 9 hours behind that can't be GMT ^^

The idea with the time including into php is not bad, but the dates are incorrect in mysql as well...

Maybe anyone else can help?

[Byron]

LAUBi I've edited your post so that it doesn't contain profanity. If you use anymore profanity I will ban you for 10 days. Read the Guidelines.

 

http://www.helionet.org/index/index.php?showtopic=4

[LAUBi]

lol, didn't even mention that... im sorry ^^

[Byron]

You can try this directive in your root htaccess file. I can't say for sure that it will work for mysql.

 

SetEnv TZ US/Eastern

 

Give me a minute and I'll post back other time zones.

 

EDIT:

 

Time Zones:

http://byrondallas.heliohost.org/php/timezone-all.php

 

 

[LAUBi]

that didn't solve it though the dates are saved wrong in the table in mysql and the php script displays only THOSE dates.. :/

 

edit: mysql is actually using the system time, isn't it?