在Python中使用cx_Oracle连接数据库并进行SQL查询时，如何将日期变量结合到查询语句中。通过使用SQLAlchemy或直接使用参数化连接，可以将日期变量绑定到SQL的BETWEEN条件中，从而解决日期格式问题。
I want to do sql query in python. I could use cx_oracle to connection database in python:
# Build connection
conn_str = u'username/password@host:1521/sid'
conn = cx_Oracle.connect(conn_str)
Now I'm trying to retrieve data from the database by using SQL query in Python:
sql_select_statement = """SELECT * FROM TABLE
WHERE DATE BETWEEN '20-oct-2017' AND '30-oct-2017'"""
Assume we don't know the starting date, we only have a date variable called starting_time, and its value is a datetime %m/%d/%Y. Also, ending_time is yesterday, I would like to modify my SQL query as:
sql_select_statement = """SELECT * FROM TABLE
WHERE DATE BETWEEN '20-oct-2017' AND sysdate-1"""
df = pd.read_sql(sql_select_statement, conn)
最低0.47元/天 解锁文章
扫一扫
1462
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
