My web server is based in the US somewhere. I've got info being inserted into mysql on the webserver, with a timestamp auto-updating. However when I display this info on my web page it shows it as being 2am instead of 8pm.
- somehow tell mySQL to add 18 hours when auto-updating the timestamp?
- Tell PHP to treat the value coming from the timestamp field as date/time and add 18 hours (therefore often the next day)?
I don't appear to have access to the configuration to set my timezone. I am going to contact the webhost support to see if I have access to change this, but I'm not holding my breath...
Anyone have any suggestions?