Re: [Haskelldb-users] Problem using CalendarTimeT column

[Justin B. <jgb...@gm...>]

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

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

Justin

On Mon, Sep 28, 2009 at 8:34 AM, Colin Paul Adams
<co...@co...> wrote:
>>>>>> "Justin" == Justin Bailey <jgb...@gm...> writes:
>
>    Justin> What driver and database are you using?
>
> Sqlite3 via HDBC.
> --
> Colin Adams
> Preston Lancashire
>