PHP / MySQL - current date/time in timezone

Question

How do request the date/time in PHP or MySQL within a timezone? I'd rather do it on the PHP side, but also would like to know if its possible in MySQL.

Answer 1

First of all, you can return Unix time, which is universal time, like that:

• in MySQL (UNIX_TIMESTAMP() documentation):

  SELECT UNIX_TIMESTAMP();
  

• in PHP (time() documentation):

  echo time();
  

If you want the time in your current time zone, you can do it like that:

• in MySQL (NOW() documentation):

  SELECT NOW();
  

• in PHP (for available formats refer to date() documentation):

  echo date('Y-m-d H:i:s');
  

Does it meet your needs?

Answer 2

SET GLOBAL time_zone = timezone;

Or per connection:

SET time_zone = timezone;