[Haskell-cafe] Re: programmatic DB interface?

[Michael Snoyman]

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

> >>>>> "Johannes" == Johannes Waldmann <waldmann at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.haskell.org/pipermail/haskell-cafe/attachments/20100204/1d2eea5e/attachment.html