Changeset 2450

Timestamp:

02/28/06 21:17:24 (3 years ago)

Author:

adrian

Message:

Added note to mysql backend about DATE_FORMAT not working. Refs #1423

Files:

• django/trunk/django/core/db/backends/mysql.py (modified) (1 diff)

django/trunk/django/core/db/backends/mysql.py

@@ -107 +107 @@
-    # MySQL doesn't support DATE_TRUNC, so we fake it by subtracting intervals.
-    # If you know of a better way to do this, please file a Django ticket.
+    # Note that we can't use DATE_FORMAT directly because that causes the output
+    # to be a string rather than a datetime object, and we need MySQL to return
+    # a date so that it's typecasted properly into a Python datetime object.
-    subtractions = ["interval (DATE_FORMAT(%s, '%%%%s')) second - interval (DATE_FORMAT(%s, '%%%%i')) minute - interval (DATE_FORMAT(%s, '%%%%H')) hour" % (field_name, field_name, field_name)]
-    if lookup_type in ('year', 'month'):