[Django]-Django group query by day with timezone specification

As it turned out, there were some mistakes in extra({…}).

So

extra({'date': "date(created) AT TIME ZONE '{0}'".format(time_zone)}

Should be changed to

extra(select={'date': "date(goods_order.created AT TIME ZONE '{0}')".format(time_zone))

where goods_order.created is database_tablename.fieldname