PHP and MySQL timestamps and time zones

Question

If I take the current timestamp using the NOW () function in MySQL, can I capture this field via php and provide this time in different time zones? Basically, converting the current time in the current time zone to another time zone?

Answer 1

You can use the class DateTimeZone:

$gmt = new DateTimeZone("GMT");
$datetimeInGMT = new DateTime($now, $gmt);

It also takes up space in the form continent/city, for example. Europe/London.

If your datetime is not UTC, you can use setTimezone:

$datetimeInGMT = new DateTime($now, new DateTimeZone("America/New_York"));
$datetimeInGMT->setTimezone(new DateTimeZone("GMT"));

Answer 2

MySQL , PHP. (EST, PST ..) , " " (America/Eastern). , , .

, , UTC, UTC_TIMESTAMP(). MySQL CONVERT_TZ() . http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

. , . http://dev.mysql.com/downloads/timezones.html