I have a query with the following line:
NVL(to_date(p.attribute7,‘YYYY/MM/DD HH24:MI:SS’), period.end_date) >= period.start_date
One of my colleagues can run this query but when I try it thinks :MI is a variable. Am I missing a setting? Does someone know what is going on here?