Javascript timezone solution needed(taking into account the actual difference in UTC timestamps)
- by user198729
I have unix timestamps from time zone X which is not known,
the current timestamp(now()) in TZ X is known 1275143019,
how to approach a javascript function so that it can generate the datetime in the users current TZ in the format 2010-05-29 15:32:35 ?
UPDATE
I'm not a unix timestamp expert,if unix timestamp is always the same in different TZ,
then I have to change the question a little,so that the current datetime in TZ X is known(like 2010-05-29 22:32:28),and the other datetime is also in this format,how to convert them to the user's TZ based on the difference between now() ?
UPDATE
Something strange from MySQL:
On server:
mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2010-05-29 18:34:30 |
+---------------------+
1 row in set (0.00 sec)
mysql> select UNIX_TIMESTAMP();
+------------------+
| UNIX_TIMESTAMP() |
+------------------+
| 1275143674 |
+------------------+
1 row in set (0.00 sec)
On local:
mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2010-05-29 22:41:30 |
+---------------------+
1 row in set (0.00 sec)
mysql> select UNIX_TIMESTAMP();
+------------------+
| UNIX_TIMESTAMP() |
+------------------+
| 1275144091 |
+------------------+
1 row in set (0.00 sec)
Why the difference between now() (2010-05-29 22:41:30-2010-05-29 18:34:30=6hours) and UNIX_TIMESTAMP() (1275144091 - 1275143674 = 417seconds) is not the same ?
