#7 Date parsing problems
Hi,
as I were writing debian package for wordpress-pg and
testing the system, I found out some problems with
dateformat handling (the dates on the pages were messed
up).
After a while I found out the reason for those
problems. The mysql2date (in wp-includes/functions.php)
depends on the actual string representation of the
timestamp. In general, this sucks, but doesn't seem to
be trivial to fix. The problem is in the php-pgsql
side: it doesn't seem to support timestamps natively,
but represents them as strings instead.
One way to fix this would be to fetch epoch instead of
the timestamp (eg. "extract(epoch from post_date)") in
all the queries related to the timestamps. Other, more
straighforward way is to force the dateformat to be the
one expected internally by wp.
Patch to fix the issue is attached.
Patch fix this bug