diff options
author | nabil-rady <midorady9999@gmail.com> | 2022-02-21 03:28:19 +0200 |
---|---|---|
committer | Mariusz Felisiak <felisiak.mariusz@gmail.com> | 2022-02-22 07:26:44 +0100 |
commit | b7f263551c64e3f80544892e314ed5b0b22cc7c8 (patch) | |
tree | 214109d91a32b72e0fd52dacfe4992a74a32e1c3 /tests/db_functions | |
parent | 659d2421c7adbbcd205604002d521d82d6b0b465 (diff) | |
download | django-b7f263551c64e3f80544892e314ed5b0b22cc7c8.tar.gz |
Refs #33517 -- Prevented __second lookup from returning fractional seconds on PostgreSQL.
Diffstat (limited to 'tests/db_functions')
-rw-r--r-- | tests/db_functions/datetime/test_extract_trunc.py | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/tests/db_functions/datetime/test_extract_trunc.py b/tests/db_functions/datetime/test_extract_trunc.py index 67a4b81766..a01778c719 100644 --- a/tests/db_functions/datetime/test_extract_trunc.py +++ b/tests/db_functions/datetime/test_extract_trunc.py @@ -899,6 +899,22 @@ class DateFunctionTests(TestCase): 2, ) + def test_extract_second_func_no_fractional(self): + start_datetime = datetime(2015, 6, 15, 14, 30, 50, 321) + end_datetime = datetime(2016, 6, 15, 14, 30, 50, 783) + if settings.USE_TZ: + start_datetime = timezone.make_aware(start_datetime) + end_datetime = timezone.make_aware(end_datetime) + obj = self.create_model(start_datetime, end_datetime) + self.assertSequenceEqual( + DTModel.objects.filter(start_datetime__second=F("end_datetime__second")), + [obj], + ) + self.assertSequenceEqual( + DTModel.objects.filter(start_time__second=F("end_time__second")), + [obj], + ) + def test_trunc_func(self): start_datetime = datetime(999, 6, 15, 14, 30, 50, 321) end_datetime = datetime(2016, 6, 15, 14, 10, 50, 123) |