gistfile1.cs

        /// <summary>
        /// Convert to ISO 8601 Date time format (Required by Sqlite)
        /// </summary>
        /// <param name="dateTime">date to convert</param>
        /// <returns>date converted to ISO8601 datetime format</returns>
        public static string ToISO8601(this DateTime dateTime)
        {
            return dateTime.ToString("u").Replace("Z", "");
        }

        public static string ToISO8601(this DateTime? dateTime)
        {
            if(dateTime.HasValue)
            return dateTime.Value.ToString("u").Replace("Z", "");

            return DateTime.MinValue.ToISO8601();
        }