django错误：TypeError: not enough arguments for format string

sql = "select id,dataflow_name,date_format(from_unixtime(dataflow_datekey),'%%Y-%%m-%%d') as dataflow_date from dataflow_info"        
dataflow_lists = Info.objects.raw(sql) 
for dataflow in dataflow_list:
    print dataflow.dataflow_date

出现错误，TypeError: not enough arguments for format string。

用户输入那边，一个字符串型的参数，含有“%”，这个“%”造成python认为此字符串有format倾向，出现错误。

%%取代%可以解决这个问题。

sql = "select id,dataflow_name,date_format(from_unixtime(dataflow_datekey),'%%Y-%%m-%%d') as dataflow_date from dataflow_info"        
dataflow_lists = Info.objects.raw(sql) 
for dataflow in dataflow_list:
    print dataflow.dataflow_date