I'm trying to send today variable into SQL but it is not working. Answer You don't have to compute today's date in Python. Just use the PostgreSQL function CURRENT_DATE:

How to insert today’s date in SQL select statement using python?

I’m trying to send today variable into SQL but it is not working.

import datetime from date

today = date.today()


stmt = "select agent_email from customer_interaction_fact where to_date(DT) >= + today + ORDER BY CONVERSATION_CREATED_TIME DESC"

JavaScript
​x
 
import datetime from date
​
today = date.today()
​
​
stmt = "select agent_email from customer_interaction_fact where to_date(DT) >= + today + ORDER BY CONVERSATION_CREATED_TIME DESC"
​

Answer

You don’t have to compute today’s date in Python. Just use the PostgreSQL function CURRENT_DATE:

stmt = "SELECT ... WHERE TO_DATE(DT) >= CURRENT_DATE ..."

JavaScript
 
stmt = "SELECT ... WHERE TO_DATE(DT) >= CURRENT_DATE ..."
​

Advertisement

Answer