Merge pull request #2395 from medspx/dbmanager_oracle_timestamp

jef-n · jef-n · commit 44590e9a712a · 2015-10-23T17:03:29.000+02:00
DBManager: support timestamp values for Oracle
diff --git a/python/plugins/db_manager/db_plugins/oracle/data_model.py b/python/plugins/db_manager/db_plugins/oracle/data_model.py
@@ -64,6 +64,9 @@ def _sanitizeTableField(self, field):
         if field.dataType.upper() == u"DATE":
             return u"CAST({} AS VARCHAR2(8))".format(
                 self.db.quoteId(field.name))
+        if u"TIMESTAMP" in field.dataType.upper():
+            return u"TO_CHAR({}, 'YYYY-MM-DD HH:MI:SS.FF')".format(
+                self.db.quoteId(field.name))
         if field.dataType.upper() == u"NUMBER":
             if not field.charMaxLen:
                 return u"CAST({} AS VARCHAR2(135))".format(
