How to display all datetime on website in user's GMT locale?

Question

I store all datetime values as unix timestamp. Registered users can set personal GMT locale in their profile. What should I do to display all datetime on website in user's GMT locale?

Thank you

Answer 1

There's no such thing as "user's GMT locale". You must be referring to the user's timezone.

You can convert unix timestamps to dates in the user timezone this way:

$timestamp = ...;
$tz = new DateTimezone("Europe/Lisbon"); //substitute by the user's timezone
$d = new DateTime("@$timestamp");
$d->setTimezone($d);
echo $d->format(DateTime::RFC822);

If you only have a GMT offset, you can use:

$tz = new DateTimezone("Etc/GMT-12");

Note, however, that if you use GMT offsets, you will have to change them when the users enter or leave daylight saving time.

Answer 2

With PHP:

date("Y-m-d H:i:s", $timestamp);

With MySQL:

FROM_UNIXTIME()