django.git/django/db/backends/sqlite3/_functions.py, branch main

Fixed #37028 -- Added BitAnd(), BitOr(), and BitXor() aggregates.

2026-04-18T06:53:21Z

Fixed #36735 -- Added UUID4 and UUID7 database functions.

2025-12-12T16:17:08Z

Co-authored-by: Mariusz Felisiak

Fixed #34262 -- Added support for AnyValue for SQLite, MySQL, Oracle, and Postgresql 16+.

2025-05-20T08:01:42Z

Thanks Simon Charette for the guidance and review. Thanks Tim Schilling for the documentation review. Thanks David Wobrock for investigation and solution proposals.

Fixed #33037 -- Fixed Trunc() with offset timezones on MySQL, SQLite, Oracle.

2024-02-15T09:02:57Z

Applied Black's 2024 stable style.

2024-01-26T11:45:07Z

https://github.com/psf/black/releases/tag/24.1.0

Refs #34233 -- Referenced isocalendar() results by names not indexes.

2023-01-18T11:57:54Z

isocalendar() returns a namedtuple() instead of tuple in Python 3.9+

Fixed #34233 -- Dropped support for Python 3.8 and 3.9.

2023-01-18T08:46:01Z

Refs #32365 -- Removed support for pytz timezones per deprecation timeline.

2023-01-17T10:49:15Z

Used more augmented assignment statements.

2022-10-31T11:30:13Z

Identified using the following command: $ git grep -I '$\<[_a-zA-Z0-9]\+\>$ *= *\1 *[-+/*^%&|<>@]'

Fixed #33553 -- Used built-in math functions in SQLite 3.35+.

2022-03-02T09:10:48Z

In SQLite 3.35+ some math functions are available built-in as long as they are not disabled at compile time. We can introspect this and use these built-in functions in preference to our slower implementations.