I'm walking into a project where a database is already set up. Up until now, the client has been working with using NOW() in PHP to store a DateTime in mysql. The problem is that now they want people from all over the world to be able to return data and have it display in their current time. So I changed all the functions from NOW() to UTC_TIMESTAMP() so the database is using UTC for all stored DateTime stamps. Looking at the table it's stored as YYYY-MM-DD HH:MM:SS. So how can I can I convert, using PHP, that timestamp from a UTC time to what it would be in their timezone?
So if I'm in GMT-6, and there is a timestamp of "2015-12-08 15:17:20" it'll display as "2015-12-08 09:17:20" on the page?
I've been looking at all sorts of PHP options, I can't really change anything in SQL, nor the database structure, all I can do is take the data being stored and manipulate it with PHP.