Re: [Haskelldb-users] Problem using CalendarTimeT column

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

On Wed, Sep 30, 2009 at 12:47 AM, Colin Paul Adams
<co...@co...> wrote:
> The reason I say this, is because I tried switching from sqlite3 to
> postgresql. It doesn't work there either. But this time, instead of
> the column being of type "timestamp", it is of type "timestamp without
> time zone", which is clearly wrong, as CalendarTime includes timezone
> information.
>

I looked into this yesterday and found pretty much the same thing. The
HaskellDB driver interface for database connections is too ridig and
doesn't allow you to specify the type you want for a DateTime column,
which in turn forces the driver implementor to decide on a parsing
strategy.

It's an unfortunate situation, but I'm glad you found a workaround. If
you feel like digging into the library to improve the API I'd be glad
to help.

Justin