id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
33602	when use date_hierarchy in admin,  it report a error.   django 3.2.12, mysql-connector-python8.0.28,  mysql server 8.0.28	Eric Pan	nobody	"\site-packages\django\db\backends\mysql\operations.py  line 58
 {{{
def date_trunc_sql(self, lookup_type, field_name, tzname=None):
        field_name = self._convert_field_to_tz(field_name, tzname)
        fields = {
            'year': '%%Y-01-01',
            'month': '%%Y-%%m-01',
        }  # Use double percents to escape.

}}}
the problem is here.
{{{
   'year': '%%Y-01-01',
            'month': '%%Y-%%m-01',
}}}

this will generate the SQL.   

{{{
SELECT DISTINCT CAST(DATE_FORMAT([table name], '%%Y-01-01') AS DATE) AS `datefield
}}}

the format `''%%Y-01-01''`  is not right for mysql.

"	Bug	closed	Database layer (models, ORM)	3.2	Normal	needsinfo			Unreviewed	0	0	0	0	0	0