Users Time Zones

[dannylewin]

Hi,

Im wanting to change the dates on my site, depending on the users time zone. I have a table that they will have selected where they are in the world... so for UK (GMT) its 0 and central USA its -6

what would the best way to convert the date/times? in the SQL statement, or using Mktime or something?

so if i had say $post_date which is in the GMT format taken from a table, how would i change this to the american central time format or what ever time zone the user is from?

Thanks in advance,

Danny

[MarkR]

The best way to convert, is to parse the string from SQL, then use gmmktime to get the unix timestamp*, then using date() to convert it into the relevant string format.

To set the user's time zone, use date_default_timezone_set. There are a bunch of strings containing common time zones, e.g. America/Los_Angeles

Then it will also take into account daylight saving time if it's relevant to that time zone. See Appendix H in the manual.

Mark

• I of course have a common function which does this; I use it everywhere.