On Thu, Feb 4, 2010 at 7:38 PM, Colin Paul Adams <[email protected]>wrote:
> >>>>> "Johannes" == Johannes Waldmann <[email protected]> > 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
_______________________________________________ Haskell-Cafe mailing list [email protected] http://www.haskell.org/mailman/listinfo/haskell-cafe
