Python执行SQL语句中日期格式化时报错：TypeError: not enough arguments for format string

使用python执行sql语句,

sql = """
        select area,
               total_confirm
          from area_detail
         where date_format(update_time, '%Y-%m-%d')=
                               (select date_format(Max(update_time), '%Y-%m-%d') as update_time
                                  from area_detail
                                 limit 1)
               and area != '湖北'
          order by total_confirm desc
             limit 10
    """

报错如下：line 140, in mogrify
query = query % self._escape_args(args, conn)
TypeError: not enough arguments for format string

解决方法：将日期格式化转中的%去掉即可