MySQL + PHP Timezone Issue

Question

I currently use $curdate=date('Y-m-d H:i:s'); to enter a timestamp to my blog's MySQL.

The problem is that the timezone of my MySQL is 2 hours ahead. At least in the timesaving period (I don't know if it is going to be any different when the timesaving period is over).

How should I redefine $curdate so that it records correct time based on PST time?

You might try date_default_timezone_set('America/Los_Angeles') in your script prior to the date() function. — Poe
– Poe, Commented Dec 15, 2011 at 13:17

DaveRandom · Accepted Answer · 2011-12-15 13:16:33Z

2

You can set the timezone the PHP uses for the duration of the execution of your script with date_default_timezone_set().

If you need to do something in your own timezone later in the execution of you script, you can call it again to set it back.

Alternatively (better?), if you use the MySQL NOW() function in your query, the time entered into the database will be calculated by MySQL, according to it's own timezone.

answered Dec 15, 2011 at 13:16

DaveRandom

88.8k11 gold badges159 silver badges174 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL + PHP Timezone Issue

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related