mysql - current_timestamp gives different time from now() in PHP? -

this question has answer here:

• php use current_timestamp eastern time zone 3 answers

in database, registration_time set current_timestamp. 7 hours early. how can correct it?

you actual mysql time different php

to check

the current values of global , client-specific time zones can retrieved this:  mysql> select @@global.time_zone, @@session.time_zone; 

to set current session, do:

set time_zone = timezonename; 

also can find detail timezone set @ link