SQL對時間格式的處理

轉換成字串再置入sql

date條件有單括號包覆日期變數

sql = “select * from tablename where date =’{}’ ”.format(datetime)

如下新增不會成功，日期會跑掉

sql= ‘Insert into {} (stock_id,date) values ({},{})’.format(‘resultdb_individual’,stockid,datetime)

如下新增成功

dt = datetime.datetime.now().strftime(“%Y-%m-%d 00:00:00”)
sql= ‘Insert into {} (stock_id,date) values (?,?)’.format(‘resultdb_individual’)
cursor.execute(sql,(‘6830’,dt))