Re: [Haskelldb-users] Problem using CalendarTimeT column

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

>>>>> "Justin" == Justin Bailey <jgb...@gm...> writes:

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

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

Which of the following will HaskellDB be using to CalendarTimeT with
sqlite-HDBC?

SqlLocalDate Day	Local YYYY-MM-DD (no timezone)
SqlLocalTimeOfDay TimeOfDay	Local HH:MM:SS (no timezone)
SqlZonedLocalTimeOfDay TimeOfDay TimeZone	Local HH:MM:SS -HHMM. Converts to and from (TimeOfDay, TimeZone).
SqlLocalTime LocalTime	Local YYYY-MM-DD HH:MM:SS (no timezone)
SqlZonedTime ZonedTime	Local YYYY-MM-DD HH:MM:SS -HHMM. Considered equal if both convert to the same UTC time.
SqlUTCTime UTCTime	UTC YYYY-MM-DD HH:MM:SS
SqlDiffTime NominalDiffTime	Calendar diff between seconds. Rendered as Integer when converted to String, but greater precision may be preserved for other types or to underlying database.
SqlPOSIXTime POSIXTime	Time as seconds since midnight Jan 1 1970 UTC. Integer rendering as for SqlDiffTime.
SqlEpochTime Integer	DEPRECATED Representation of ClockTime or CalendarTime. Use SqlPOSIXTime instead.
SqlTimeDiff Integer	DEPRECATED Representation of TimeDiff. Use
SqlDiffTime instead. 

-- 
Colin Adams
Preston Lancashire