Hi,
I created a new date/time integration for cl-postgres.
https://github.com/chaitanyagupta/cl-postgres-datetime
There's nothing fancy -- it just uses local-time to parse timestamptz and simple-date for other types (which don't use a timezone).
Why? Because neither local-time nor simple-date alone work well with all the date/time types that Postgres supports.
local-time's TIMESTAMP is a natural fit for timestamptz, and while non-timezone types like timestamp and date could be parsed into it, the user has to remember to always use +UTC-ZONE+ when decoding such a timestamp (the values of decoded components may mismatch with the original if the default time zone were different from UTC).
simple-date has no concept of time zones, so while it works well for every type that doesn't need a timezone, it fails badly when it comes to timestamptz.
Hope someone finds it useful.
Chaitanya --- lisper.in deftask.com