[wp-hackers] Re: Sqlite

[Jeff Minard]

Robert Deaton wrote:
> Storing just a unix timestamp and the offset means more parsing every
> time dates need to be seen, instead of just once and throwing it into
> the database.

So instead of:

	date($blog_date_format, $post_date)

you'd do:

	date($blog_date_format, $unix_timestamp_post_date + 
$gmt_offset_converted_to_seconds_difference)

Doesn't seem like a far strech to me.

Jeff