match time zone of mysql with php server

Question

php server time from echo date_default_timezone_get ( void ); function is this Asia/Karachi

And mysql time zone from SHOW VARIABLES LIKE '%time_zone' query is this system_time_zone : CST

now how can I change MysQl time zone to match with my php server time.

Due to this difference the php date() and mysql current_timestamp are giving different results.

For God's sake, don't just upvote the comment, cast actual votes! — Álvaro González, Mar 12 '14 at 12:58

score 1 · Answer 1 · answered Mar 12 '14 at 12:54

1

SET GLOBAL time_zone = 'Asia/Karachi';

answered Mar 12 '14 at 12:54

Karthick Kumar

score 0 · Answer 2 · answered Mar 12 '14 at 12:55

0

Try this in your database

SET time_zone = 'Asia/Karachi';

answered Mar 12 '14 at 12:55

zzlalani

2 Answers2