MYSQL Timezone


#1

Hi,

I’m living in Europe but I would like to have mysql running in my local timezone.

Now when I do NOW() I get the timezone of the server.

I already tried what was suggested in

But this didn’t work.

Any help!


#2

For MySQL, I think you can only have one timezone set per mysql daemon. You could use something like

SELECT DATE_ADD(NOW(), INTERVAL 2 HOUR); Dunno if that works for you.

I suppose that if you sign up for MySQL PS, it’s possible they could set the timezone of your MySQL server to one different from the shared MySQL servers.

Free unique IP and $67 off with code [color=#CC0000]LMIP67[/color] or use [color=#CC0000]LM97[/color] for $97 off. Click for other Dreamhost coupons / promo codes


#3

Myeah,

that’s no option…

or I should edit the src of the cms I’m working with…