LAUBi Posted January 8, 2010 Share Posted January 8, 2010 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 Quote Link to comment Share on other sites More sharing options...
openmp3 Posted January 11, 2010 Share Posted January 11, 2010 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. Quote Link to comment Share on other sites More sharing options...
LAUBi Posted January 11, 2010 Author Share Posted January 11, 2010 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? Quote Link to comment Share on other sites More sharing options...
Byron Posted January 11, 2010 Share Posted January 11, 2010 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 Quote Link to comment Share on other sites More sharing options...
LAUBi Posted January 11, 2010 Author Share Posted January 11, 2010 lol, didn't even mention that... im sorry ^^ Quote Link to comment Share on other sites More sharing options...
Byron Posted January 11, 2010 Share Posted January 11, 2010 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 Quote Link to comment Share on other sites More sharing options...
LAUBi Posted January 11, 2010 Author Share Posted January 11, 2010 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? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.