Re: [Haskell-cafe] Re: programmatic DB interface?

On Thu, Feb 4, 2010 at 7:38 PM, Colin Paul Adams wrote:

...

...

...

...

...

"Johannes" == Johannes Waldmann 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