python连接数据库

python连接mysql使用时间戳筛选

sql语句sql = "select * from robot_all where createtime = %s;" % timeStamp

报错
query = query % db.literal(args)
TypeError: not all arguments converted during string formatting

时间要用单引号引起来
此外，用format函数可读性更强一些
"select * from robot_all where createtime = '{}';".format( timeStamp)