Binding dates to SQL in Python for cx_Oracle

Question

I am using the following query to select logs fro a logs table.

SELECT * FROM LOGS  WHERE LOG_DATE BETWEEN TO_TIMESTAMP(:date_start, 'MM-DD-YYYY') AND TO_TIMESTAMP(:date_end, 'MM-DD-YYYY')

I have the following dictionary of parameters:

{'date_start': '02-24-20', 'date_end': '02-24-20'}

and executing the query as follows :

cursor.execute(query, params)

Now the problem is I am not getting any values for this date range. But if I execute the query in Oracle, by specifying the dates, it is working. What is wrong here ?

Littlefoot · Accepted Answer · 2020-02-24 07:36:08Z

3

If you specified format mask as 'MM-DD-YYYY', why do you then provide only two digits for year ('02-24-20')? Provide 4 digits.

answered Feb 24, 2020 at 7:36

Littlefoot

144k15 gold badges41 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Binding dates to SQL in Python for cx_Oracle

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related