Make PostGIS provider correctly use time and datetime formats, instea…

…d of converting them to character
qgis · Mar 25, 2014 · 013f9e9 · 013f9e9
1 parent d8ad1d8
commit 013f9e9
Showing 1 changed file with 6 additions and 0 deletions.
diff --git a/src/providers/postgres/qgspostgresprovider.cpp b/src/providers/postgres/qgspostgresprovider.cpp
@@ -2788,7 +2788,13 @@ bool QgsPostgresProvider::convertField( QgsField &field )
       break;
 
     case QVariant::DateTime:
+      fieldType = "timestamp without time zone";
+      break;
+
     case QVariant::Time:
+      fieldType = "time";
+      break;
+
     case QVariant::String:
       fieldType = "varchar";
       fieldPrec = -1;