current_timestamp给出了PHP中now（）的不同时间？ [重复]

Question

This question already has an answer here:

• PHP use CURRENT_TIMESTAMP from eastern time zone 3 answers

In my database, registration_time is set to current_timestamp. But it is 7 hours early. How can I correct it?

</div>

Answer 1

you actual mysql time is different then you php

to check

The current values of the global and client-specific time zones can be retrieved like this: 
mysql> SELECT @@global.time_zone, @@session.time_zone;

To set it for the current session, do:

SET time_zone = timezonename;

Also you can find detail about timezone set at this link