Re: [pLog-General] About timezones...

[Oscar R. <os...@re...>]

> If we were using unix timestamps instead of the mysql timestamp function
> it would be fairly easy... just have the user input the TZ he's in, and
> the TZ the server is in. Take the timestamp, convert it to GMT, then
> convert to user's time, unless the timezones matched (no need for
> useless math, eh?)
>
> As for what we have now, we'd still have to know User TZ and Server TZ,
> but it's going to require more work to handle converting the time since
> we have to rip apart the time stamp and basically do the math by hand,
> plus taking into account how we handle the 23:59:59 / 00:00:00 barrier....

Perhaps it's not that difficult because we can easily convert from MySQL 
TIMESTAMP format to unix timestamps using PHP functions such as mktime and 
strtotime, since the Timestamp class that encapsulates TIMESTAMP inside pLog 
already offers methods for getting the minutes, seconds, day, year and so on 
out of a TIMESTAMP(14) date.

Or heck, now that I think of it:

SELECT UNIX_TIMESTAMP(date) FROM plog_articles;

Once we can get the unix timestamp, and according to what you say, then it 
should be easier, right? :)

Oscar.