Jump to content

How To Change The Timezone From Mysql(I) ?


Recommended Posts

Posted

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 ?

Posted

What is the script used in your site

Posted

$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

Posted

you can change the Timezone from setting of your script

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...