gigagames Posted October 2, 2015 Posted October 2, 2015 Hello,how can i change the Timezone from the Database (at PHP?)i try everything i foundet, nothing works -.-Here what i have tried:$db->options(MYSQLI_INIT_COMMAND, "SET time_zone = 'Europe/Berlin'");$db->options(MYSQLI_INIT_COMMAND, "SET time_zone = '+01:00'");$db->query("SET time_zone = 'Europe/Berlin'");$db->query("SET time_zone = '+01:00'");and whit session and global bevor time zone but its still using the server time why ?
gigagames Posted October 3, 2015 Author Posted October 3, 2015 $db = new mysqli('localhost', '....', '....', '....'); $db->set_charset("UTF8") THEN I HAVE ADDED ONE OF THE "COMMANDS" FROM THE FIRST POST $stmt = $db->prepare(INSERT INTO ... (A,B,C) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE A = VALUES(A), C = VALUES(C), LastUpdate = NOW(); $stmt->bind_param(iss, ......); $stmt->excecute(); Then if i check in Mysql the Timestamp is convertet to a date, but its a wrong clock, becouse its still use the Time_zone from the server and not my thet i have set
alein Posted October 5, 2015 Posted October 5, 2015 you can change the Timezone from setting of your script
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now