fix datetime colume truncated error

Robert Lu · Robert Lu · commit 93c7b3808970 · 2017-02-28T00:15:47.000+08:00
error esg:
  DatabaseError: Data truncated for column &lt;applied&gt; at row 1
diff --git a/lib/mysql/connector/django/operations.py b/lib/mysql/connector/django/operations.py
@@ -43,6 +43,22 @@ def date_extract_sql(self, lookup_type, field_name):
             return "EXTRACT({0} FROM {1})".format(
                 lookup_type.upper(), field_name)
 
+    def adapt_datetimefield_value(self, value):
+        if value is None:
+            return None
+
+        # MySQL doesn't support tz-aware datetimes
+        if timezone.is_aware(value):
+            if settings.USE_TZ:
+                value = timezone.make_naive(value, self.connection.timezone)
+            else:
+                raise ValueError("MySQL backend does not support timezone-aware datetimes when USE_TZ is False.")
+
+        if not self.connection.features.supports_microsecond_precision:
+            value = value.replace(microsecond=0)
+
+        return force_text(value)
+
     def date_trunc_sql(self, lookup_type, field_name):
         """Returns SQL simulating DATE_TRUNC
 
