https://ovarimovi.rf.gd
https://ovarmovie.rf.gd
The sql server’s timezone is different from my timezone and it is creating a problem for my analytics session and i am requesting admin to change both of the sites sql server’s timezone if possible
It cannot be changed; however, you can store the date and time with the desired timezone using your own function
You already answered the question yourself. It’s the server timezone. It’s the same for the entire database server. If we would have to change it for you, then the server time zone would also be changed for everyone else on the same server, which will cause a lot more problems.
You can however change the time zone just for your website in PHP, to set it to your local time zone. But then you have to make sure to only ever generate dates and times through PHP, and never let MySQL generate time for you (using NOW() or CURRENT_TIME() or similar functions).
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.