On Thu, Feb 4, 2010 at 7:38 PM, Colin Paul Adams <colin@colina.demon.co.uk> wrote:

>>>>> "Johannes" == Johannes Waldmann <waldmann@imn.htwk-leipzig.de> writes:

Johannes> anyone know what's happening here? I get this when
Johannes> executing a query via haskelldb-hdbc-postgresql-0.12 (The
Johannes> date is actually in the DB, so it's not a connection
Johannes> problem.)

Johannes> Convertible: error converting source data SqlString
Johannes> "2008-10-29 00:00:00" of type SqlValue to type
Johannes> Data.Time.LocalTime.LocalTime.LocalTime: Cannot parse
Johannes> using default format string "%Y-%m-%dT%T%Q"

I had this sort of problem. I sent a patch on the haskell-db list to use
UTC - I believe the release behaviour is incorrect.

You might check the list archives, as they have a better memory than I.

I actually just came up against this as well in HDBC-postgresql. As a workaround, when I read a timestamp I concatenate with an empty string (||'') and then read with my own parse string:

"%Y-%m-%d %T%Q"

This seems to work just fine. I'd like to debug it more, but I'm working on a short-deadline project. Hopefully when the month is out I'll be able to submit some patches for the problems I've run into. The other one that comes to mind off hand is I can't write to BYTEA fields either.

Michael