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 duncmc · Accepted Answer · 2011-02-03T20:38:09

5

votes

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

PHP convert MySQL datetime to Unix Timestamp

2 Answers