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