[Haskelldb-users] Problem using CalendarTimeT column

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

I've tried declaring a column of type CalendarTimeT. 

I inserted a record using the variable time, which I got like this:

ct <- getClockTime
time <- toCalendarTime ct

as that seemd to be the way to produce a calendar time from reading
the docs for System.Time.

However, on reading the record back, I get:

Server error: Convertible: error converting source data SqlString
"2009-09-28 11:48:37" of type SqlValue to type
Data.Time.LocalTime.LocalTime.ZonedTime: Cannot parse using default
format string "%Y-%m-%d %T%Q %z"

What have I missed?
-- 
Colin Adams
Preston Lancashire