Re: [Haskelldb-users] Problem using CalendarTimeT column

[Colin P. A. <co...@co...>]

>>>>> "Justin" == Justin Bailey <jgb...@gm...> writes:

    Justin> As far as I can tell, this is an issue with HDBC's
    Justin> Convertible class/package more than haskelldb. The
    Justin> instance of Convertible for the time type
    Justin> (Data.Time.LocalTime.LocalTime.ZonedTime) is apparently
    Justin> trying to use the format string "%Y-%m-%d %T%Q %z" to
    Justin> parse the data.  Notice %z - that is a time zone
    Justin> specifier, and it does not show up in the example value
    Justin> ("2009-09-28 11:48:37").

    Justin> If you can manage to get your own instance of Convertible
    Justin> defined, you should be able to define your own format
    Justin> string to parse the data.  Alternatively, if you can get
    Justin> SqlLite to include timezone information you can probably
    Justin> get the value to parse.

I suspect the problem is with the insert.

For the SELECT, I can use showSQL to see the generated SQL. How can I
find out what SQL the insert is generating?
-- 
Colin Adams
Preston Lancashire