PHP convert MySQL datetime to Unix Timestamp

Question

I'm confused about timezone differences when converting a MySQL datetime to Unix timestamp. It appears to me that MySQL datetimes (2011-02-07 09:45:00) are in the server's local timezone. I want to convert this datetime into a Unix timestamp, which is always in the GMT timezone. To do this conversion, PHP passes the datetime into strtotime. The datetime string contains no timezone, so will strtotime assume the argument is local timezone or GMT?

duncmc · Accepted Answer · 2011-02-03 20:38:09Z

5

The strtotime function will assume the datetime is in the server's local timezone.

answered Feb 3, 2011 at 20:38

duncmc

9685 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jan · Accepted Answer · 2011-02-03 20:31:29Z

0

Why not use MySQL's UNIX_TIMESTAMP() function?

answered Feb 3, 2011 at 20:31

Jan

2,2931 gold badge17 silver badges16 bronze badges

1 Comment

Cassandra Over a year ago

Because the project running on the server, and the sever are in two different timezones. Referring the servers timezone will give wrong data to the site user. I've used php's date_default_timezone_set('XXX'); to change the default timezone for the site.

Collectives™ on Stack Overflow

PHP convert MySQL datetime to Unix Timestamp

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related