summaryrefslogtreecommitdiff
path: root/tests/db_functions/datetime
diff options
context:
space:
mode:
Diffstat (limited to 'tests/db_functions/datetime')
-rw-r--r--tests/db_functions/datetime/test_extract_trunc.py23
1 files changed, 23 insertions, 0 deletions
diff --git a/tests/db_functions/datetime/test_extract_trunc.py b/tests/db_functions/datetime/test_extract_trunc.py
index a129448470..71d9b676ed 100644
--- a/tests/db_functions/datetime/test_extract_trunc.py
+++ b/tests/db_functions/datetime/test_extract_trunc.py
@@ -1210,6 +1210,29 @@ class DateFunctionWithTimeZoneTests(DateFunctionTests):
self.assertEqual(melb_model.hour, 9)
self.assertEqual(melb_model.hour_melb, 9)
+ def test_extract_func_with_timezone_minus_no_offset(self):
+ start_datetime = datetime(2015, 6, 15, 23, 30, 1, 321)
+ end_datetime = datetime(2015, 6, 16, 13, 11, 27, 123)
+ start_datetime = timezone.make_aware(start_datetime)
+ end_datetime = timezone.make_aware(end_datetime)
+ self.create_model(start_datetime, end_datetime)
+ for ust_nera in self.get_timezones('Asia/Ust-Nera'):
+ with self.subTest(repr(ust_nera)):
+ qs = DTModel.objects.annotate(
+ hour=ExtractHour('start_datetime'),
+ hour_tz=ExtractHour('start_datetime', tzinfo=ust_nera),
+ ).order_by('start_datetime')
+
+ utc_model = qs.get()
+ self.assertEqual(utc_model.hour, 23)
+ self.assertEqual(utc_model.hour_tz, 9)
+
+ with timezone.override(ust_nera):
+ ust_nera_model = qs.get()
+
+ self.assertEqual(ust_nera_model.hour, 9)
+ self.assertEqual(ust_nera_model.hour_tz, 9)
+
def test_extract_func_explicit_timezone_priority(self):
start_datetime = datetime(2015, 6, 15, 23, 30, 1, 321)
end_datetime = datetime(2015, 6, 16, 13, 11, 27, 123)