datetime in SQL query.

[Dibbley]

Hi

I'm using the code below to import from an ODBC database. At the moment I'm hard-coding the dates, for example, I can't work out the syntax to replace the second date with datetime.today().strftime('%Y-%m-%d'). Could anyone offer a suggestion where I'm going wrong.

columns_to_select = ['STOCK_CODE, RECORD_CREATE_DATE, TRAN_NUMBER, COST_PRICE, QUANTITY, TYPE']

# Construct the query
sql_query = f"""
SELECT {', '.join(columns_to_select)}
FROM STOCK_TRAN
WHERE RECORD_CREATE_DATE >= '2023-01-31' AND RECORD_CREATE_DATE < '2025-09-17'
"""
# Execute the query
df = pd.read_sql_query(sql_query, conn)


Thanks

[Larz60+]

I'd suggest taking a gander at Date and Time Value Manipulation. This site has been around for a while, but stands solidly. It shown examples of each time of conversion. Don't forget to import datetime.

[Dibbley]

I'd suggest taking a gander at Date and Time Value Manipulation. This site has been around for a while, but stands solidly. It shown examples of each time of conversion. Don't forget to import datetime.

Thanks, I've already looked at that, and I already use datetime successfully already, specifically I can't seem to get the syntax working within the SQL query.

[Dibbley]

I've figured it out. I needed squiggly brackets

WHERE RECORD_CREATE_DATE >= '2023-01-31' AND RECORD_CREATE_DATE < '{datetime.today().strftime('%Y-%m-%d')}'