Database.SQLite.Simple.Time.Implementation

Adapted from Leon P Smith's code for SQLite.

See http://sqlite.org/lang_datefunc.html for date formats used in SQLite.

Documentation

parseUTCTime :: Text -> Either String UTCTime

parseDay :: Text -> Either String Day

utcTimeToBuilder :: UTCTime -> Builder

Output YYYY-MM-DD HH:MM:SS with an optional .SSS fraction part. Explicit timezone attribute is not appended as per SQLite3's datetime conventions.

dayToBuilder :: Day -> Builder

timeOfDayToBuilder :: TimeOfDay -> Builder

timeZoneToBuilder :: TimeZone -> Builder