id summary reporter owner description type status component version severity resolution keywords cc stage has_patch needs_docs needs_tests needs_better_patch easy ui_ux 30224 Mysql Datetime value is string instead of datetime object Martin Kuhn nobody "**The Problem** Datetimes are sometimes returned as objects or strings. It depends on the value. E.g. '2019-03-01 00:00:00.000000' is returned as a string, while`2018-12-12 22:02:53.134000` is provided as a datetime object in the sql/compiler.py. **My Table** > > CREATE TABLE `myTable` ( > `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, > `created_on` datetime(6) NOT NULL, > `modified_on` datetime(6) NOT NULL, > `first_spot_broadcast` datetime(6) DEFAULT NULL, > `expiry_date` datetime(6) DEFAULT NULL > ) DB driver: django.db.backends.mysql Django version: 2.0.4 tried 2.2 as well DRF 3.8.2 mysqlclient = ""==1.4.2"" This issue only occurred for me when I execute this query. {{{ .annotate( minExpiryDate=Min('buyout__expiry_date', filter=Q(buyout__is_archived=False, buyout__is_deleted=False))) \ .filter(Q(minExpiryDate__gte=(now + expiryInterval)) & Q(minExpiryDate__lte=(now + expiryInterval + timedelta(days=1)))) }}} I tried upgrading to 2.2 and the issue persisted. **My stack trace is: ** {{{ Traceback (most recent call last): File ""/usr/share/pycharm/helpers/pydev/pydevd.py"", line 1741, in main() File ""/usr/share/pycharm/helpers/pydev/pydevd.py"", line 1735, in main globals = debugger.run(setup['file'], None, None, is_module) File ""/usr/share/pycharm/helpers/pydev/pydevd.py"", line 1135, in run pydev_imports.execfile(file, globals, locals) # execute the script File ""/usr/share/pycharm/helpers/pydev/_pydev_imps/_pydev_execfile.py"", line 18, in execfile exec(compile(contents+""\n"", file, 'exec'), glob, loc) File ""/server/manage.py"", line 15, in execute_from_command_line(sys.argv) File ""site-packages/django/core/management/__init__.py"", line 381, in execute_from_command_line utility.execute() File ""site-packages/django/core/management/__init__.py"", line 375, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File ""site-packages/django/core/management/base.py"", line 316, in run_from_argv self.execute(*args, **cmd_options) File ""site-packages/django/core/management/base.py"", line 353, in execute output = self.handle(*args, **options) File ""/server/buyout/management/commands/send_expiry_reminder_email.py"", line 8, in handle send_expiry_reminder_summary() File ""site-packages/celery/local.py"", line 191, in __call__ return self._get_current_object()(*a, **kw) File ""site-packages/celery/app/task.py"", line 375, in __call__ return self.run(*args, **kwargs) File ""/server/buyout/tasks/expiry_reminder.py"", line 46, in send_expiry_reminder_summary if len(projects_expiring) > 0: File ""site-packages/django/db/models/query.py"", line 250, in __len__ self._fetch_all() File ""site-packages/django/db/models/query.py"", line 1186, in _fetch_all self._result_cache = list(self._iterable_class(self)) File ""site-packages/django/db/models/query.py"", line 63, in __iter__ for row in compiler.results_iter(results): File ""site-packages/django/db/models/sql/compiler.py"", line 1009, in apply_converters value = converter(value, expression, connection) File ""site-packages/django/db/backends/mysql/operations.py"", line 252, in convert_datetimefield_value value = timezone.make_aware(value, self.connection.timezone) File ""site-packages/django/utils/timezone.py"", line 264, in make_aware return timezone.localize(value, is_dst=is_dst) File ""site-packages/pytz/__init__.py"", line 222, in localize if dt.tzinfo is not None: AttributeError: 'str' object has no attribute 'tzinfo' Exception ignored in: Traceback (most recent call last): File ""site-packages/django/db/models/sql/compiler.py"", line 1469, in cursor_iter cursor.close() File ""site-packages/MySQLdb/cursors.py"", line 86, in close while self.nextset(): File ""site-packages/MySQLdb/cursors.py"", line 136, in nextset nr = db.next_result() MySQLdb._exceptions.OperationalError: (2006, '') }}} " Uncategorized new Uncategorized 2.2 Normal Mysql Unreviewed 0 0 0 0 0 0