连接Oracle数据库进行数据查询时,将日期作为变量(date),赋值与SQL应用写法如下所示:
var_30 = datetime.timedelta(days=var) # 设置时间长度
next_time = now_time - var_30
ac_dt = next_time.strftime('%Y/%m/%d') #转换显示格式
self.params = {'ac_dt':ac_dt}
sql1 = "select y.* from merc_statis_daily y where y.T41_TRM_NO=:T41_TRM_NO and y.ac_dt=to_date(:ac_dt,'yyyy/MM/dd')" \
"and y.pos_name = '09' AND y.card_type = '01'"
ReadDB().get_sql_one(sql1, self.params)
将变量存放在字典中,SQL语句中用to_date(:ac_dt,‘yyyy/MM/dd’)方式调用