[wp-hackers] Re: Sqlite

[Martin Geisler]

Kimmo Suominen <kimmo+key+wordpress.c4f53f at suominen.com> writes:

> AFAICT the big reason for both "local" and GMT (equivalent of
> seconds since unix epoch) times in the database is permalink
> support. The local time is needed to keep the permalinks from
> changing.

That doesn't mean that one couldn't use a Unix epoch timestamp: store
the (GMT) post date as a Unix timestamp and store a time zone offset
along with it. Then calculate the local time based on that.

Notice that this wont cost more that what is already done today where
all timestamps are offset by the global gmt_offset setting.

-- 
Martin Geisler                                     GnuPG Key: 0x7E45DD38

PHP EXIF Library      |  PHP Weather             |  PHP Shell
http://pel.sf.net/    |  http://phpweather.net/  |  http://mgeisler.net/
Read/write EXIF data  |  Show current weather    |  A shell in a browser
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 188 bytes
Desc: not available
Url : http://comox.textdrive.com/pipermail/wp-hackers/attachments/20050623/7ece34a1/attachment.bin