From 3e09b37f80ab34cf57e245e1fcdabb3d4ff92a38 Mon Sep 17 00:00:00 2001 From: Sigurd Ljødal Date: Thu, 28 Sep 2017 22:28:48 +0200 Subject: Fixed #28649 -- Added ExtractIsoYear database function and iso_year lookup. --- django/db/backends/sqlite3/base.py | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'django/db/backends/sqlite3') diff --git a/django/db/backends/sqlite3/base.py b/django/db/backends/sqlite3/base.py index 20905c83b8..d124fcd47b 100644 --- a/django/db/backends/sqlite3/base.py +++ b/django/db/backends/sqlite3/base.py @@ -338,6 +338,8 @@ def _sqlite_date_extract(lookup_type, dt): return dt.isocalendar()[1] elif lookup_type == 'quarter': return math.ceil(dt.month / 3) + elif lookup_type == 'iso_year': + return dt.isocalendar()[0] else: return getattr(dt, lookup_type) @@ -410,6 +412,8 @@ def _sqlite_datetime_extract(lookup_type, dt, tzname): return dt.isocalendar()[1] elif lookup_type == 'quarter': return math.ceil(dt.month / 3) + elif lookup_type == 'iso_year': + return dt.isocalendar()[0] else: return getattr(dt, lookup_type) -- cgit v1.3