Re: [Haskelldb-users] Problem using CalendarTimeT column

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

>>>>> "Colin" == Colin Paul Adams <co...@co...> writes:

    Colin> I've tried declaring a column of type CalendarTimeT.  I
    Colin> inserted a record using the variable time, which I got like
    Colin> this:

    Colin> ct <- getClockTime time <- toCalendarTime ct

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

    Colin> However, on reading the record back, I get:

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

    Colin> What have I missed?

I changed:

time <- toCalendarTime ct

to:

let time = toUTCTime ct

but I still get the same error.
-- 
Colin Adams
Preston Lancashire