Re: [Haskelldb-users] Problem using CalendarTimeT column

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

What driver and database are you using?

On Mon, Sep 28, 2009 at 8:07 AM, Colin Paul Adams
<co...@co...> wrote:
>>>>>> "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
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry&reg; Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9&#45;12, 2009. Register now&#33;
> http://p.sf.net/sfu/devconf
> _______________________________________________
> Haskelldb-users mailing list
> Has...@li...
> https://lists.sourceforge.net/lists/listinfo/haskelldb-users
>