zoreli — 2011-04-04T08:43:28-04:00 — #1
I have the following query:
$query1 = "INSERT INTO whoisonline VALUES (NULL,'$memberid', FROM_UNIXTIME('$lastlogin'), '$loggedfromip')";
This query works like a charm, however, I have the following problem.
The time inserted is local time on server which beloing to time zone 'America/Denver'
I would like the time inserted to be 'Europe/Athens' time zone. I try with:
without any success however. Any help will be deeply appreciated.
r937 — 2011-04-04T09:30:52-04:00 — #2
zoreli — 2011-04-04T19:36:02-04:00 — #3
It won't, since I am on shared hosting. I have no permissions to do any of the things mentioned on the page. Any other way? Any idea how to rewrite the query eventually?
r937 — 2011-04-04T20:03:24-04:00 — #4
instead of inserting FROM_UNIXTIME($lastlogin), insert FROM_UNIXTIME($lastlogin + 8*60*60)