Simple question, probably, but I cannot seem to find an answer anywhere. In my database I am saving the "start time" of events like below:
Now I have the following issue. I want users to display the time in their own timezone. I accomplished this using the "Europe/Amsterdam" functoin, but I am now integrating my script into my Invision Power Board Forums, which is using a different approach to timezones. The IPB Forums save the timezone as "1" or "-1" for example.
Example. In my database the start time has been stored as 1:00. Doesn't matter if it's PM or AM. That is the time in GMT. A user's timezone is "+5". How can I display the start time of the event in their own timezone? They should be seeing "04:00". I cannot take the "11:00" and just add +5 to it, because it would end up like "16:00" instead of "04:00".