drydart
diff --git a/‎CHANGELOG.md‎
Lines changed: 1 addition & 0 deletions b/‎CHANGELOG.md‎
Lines changed: 1 addition & 0 deletions
diff --git a/‎README.md‎
Lines changed: 1 addition & 1 deletion b/‎README.md‎
Lines changed: 1 addition & 1 deletion
diff --git a/‎lib/src/cursor.dart‎
Lines changed: 20 additions & 4 deletions b/‎lib/src/cursor.dart‎
Lines changed: 20 additions & 4 deletions
@@ -8,6 +8,7 @@ and this project adheres to [Semantic Versioning](https://semver.org/spec/v2.0.0
 
 ## [0.1.6] - 2018-11-30
 ### Added
+- `SQLiteCursor#getBool()` method
 
 ## [0.1.5] - 2018-11-30
 ### Added
 
@@ -129,7 +129,7 @@ Reference
 - [`SQLiteDatabase#beginTransactionNonExclusive()`](https://pub.dartlang.org/documentation/flutter_sqlcipher/latest/sqlite/SQLiteDatabase/beginTransactionNonExclusive.html)
 - [`SQLiteDatabase#endTransaction()`](https://pub.dartlang.org/documentation/flutter_sqlcipher/latest/sqlite/SQLiteDatabase/endTransaction.html)
 - [`SQLiteDatabase#execSQL()`](https://pub.dartlang.org/documentation/flutter_sqlcipher/latest/sqlite/SQLiteDatabase/execSQL.html)
-- [`SQLiteDatabase#getAttachedDbs`](https://pub.dartlang.org/documentation/flutter_sqlcipher/latest/sqlite/SQLiteDatabase/getAttachedDbs.html)
+- [`SQLiteDatabase#getAttachedDbs()`](https://pub.dartlang.org/documentation/flutter_sqlcipher/latest/sqlite/SQLiteDatabase/getAttachedDbs.html)
 - [`SQLiteDatabase#getMaximumSize()`](https://pub.dartlang.org/documentation/flutter_sqlcipher/latest/sqlite/SQLiteDatabase/getMaximumSize.html)
 - [`SQLiteDatabase#getPageSize()`](https://pub.dartlang.org/documentation/flutter_sqlcipher/latest/sqlite/SQLiteDatabase/getPageSize.html)
 - [`SQLiteDatabase#getPath()`](https://pub.dartlang.org/documentation/flutter_sqlcipher/latest/sqlite/SQLiteDatabase/getPath.html)
 
@@ -22,17 +22,33 @@ class SQLiteCursor extends MatrixCursor {
   SQLiteCursor.from({@required List<String> columns, @required List<List<dynamic>> rows})
     : super.from(columns: columns, rows: rows);
 
+  /// Returns the value of the requested column as a boolean.
+  ///
+  /// See: https://www.sqlite.org/datatype3.html#boolean_datatype
+  bool getBool(final int columnIndex) {
+    switch (getType(columnIndex)) {
+      case Cursor.FIELD_TYPE_NULL:
+        return null;
+      case Cursor.FIELD_TYPE_INTEGER:
+        return getInt(columnIndex) != 0;
+      default:
+        throw SQLiteDatatypeMismatchException();
+    }
+  }
+
   /// Returns the value of the requested column as a UTC instant in time.
   ///
-  /// See: https://www.sqlite.org/lang_datefunc.html
+  /// See: https://www.sqlite.org/datatype3.html#date_and_time_datatype
   DateTime getDateTime(final int columnIndex) {
     switch (getType(columnIndex)) {
       case Cursor.FIELD_TYPE_NULL:
         return null;
-      case Cursor.FIELD_TYPE_INTEGER:
-        return DateTime.fromMillisecondsSinceEpoch(getInt(columnIndex), isUtc: true);
-      case Cursor.FIELD_TYPE_STRING:
+      case Cursor.FIELD_TYPE_STRING:  // ISO-8601 strings ("YYYY-MM-DD HH:MM:SS.SSS")
         return DateTime.parse(getString(columnIndex)); // TODO: default timezone?
+      case Cursor.FIELD_TYPE_INTEGER: // Unix time, seconds since 1970-01-01T00:00:00Z
+        return DateTime.fromMillisecondsSinceEpoch(getInt(columnIndex) * 1000, isUtc: true);
+      case Cursor.FIELD_TYPE_FLOAT:   // Julian day numbers
+        // TODO: implement support for Julian day numbers; for now, fall through:
       default:
         throw SQLiteDatatypeMismatchException();
     }