System.Data.SQLite
Check-in [e7ba6b83c2]
Not logged in

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Added a few new ISO8601 datetime conversion patterns
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | sourceforge
Files: files | file ages | folders
SHA1: e7ba6b83c2b9c56e04599e7c12db2cb0fa9ce4de
User & Date: rmsimpson 2005-11-18 15:36:40
Context
2005-11-18
15:37
Modified coersion code to allow more flexibility and fix inherent bugs check-in: 1f1116559d user: rmsimpson tags: sourceforge
15:36
Added a few new ISO8601 datetime conversion patterns check-in: e7ba6b83c2 user: rmsimpson tags: sourceforge
2005-11-11
22:01
1.0.22.0 check-in: a8dc0d117d user: rmsimpson tags: sourceforge
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to System.Data.SQLite/SQLiteConvert.cs.

   108    108     /// This base class provides datatype conversion services for the SQLite provider.
   109    109     /// </summary>
   110    110     public abstract class SQLiteConvert
   111    111     {
   112    112       /// <summary>
   113    113       /// An array of ISO8601 datetime formats we support conversion from
   114    114       /// </summary>
   115         -    private static string[] _datetimeFormats = new string[] {"yyyy-MM-dd HH:mm:ss",
   116         -																	  "yyyyMMddHHmmss",
   117         -																	  "yyyyMMddTHHmmssfffffff",
   118         -																	  "yyyy-MM-dd",
   119         -																	  "yy-MM-dd",
   120         -																	  "yyyyMMdd",
   121         -																	  "HH:mm:ss",
   122         -																	  "THHmmss"
   123         -															 };
          115  +    private static string[] _datetimeFormats = new string[] {
          116  +      "yyyy-MM-dd HH:mm:ss",
          117  +      "yyyy-MM-dd HH:mm",                               
          118  +      "yyyyMMddHHmmss",
          119  +      "yyyyMMddHHmm",
          120  +      "yyyyMMddTHHmmssfffffff",
          121  +      "yyyy-MM-dd",
          122  +      "yy-MM-dd",
          123  +      "yyyyMMdd",
          124  +      "HH:mm:ss",
          125  +      "HH:mm",
          126  +      "THHmmss",
          127  +      "THHmm"
          128  +    };
   124    129   
   125    130       /// <summary>
   126    131       /// An UTF-8 Encoding instance, so we can convert strings to and from UTF-8
   127    132       /// </summary>
   128    133       private Encoding _utf8 = new UTF8Encoding();
   129    134       /// <summary>
   130    135       /// The default DateTime format for this instance