Query Problem 'YYYY/MM/DD HH24:MI:SS'

Toad for Oracle & DevOps Toolkit
1

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?

Thanks,
Fran

2

One possibility is that you could check your “define” setting.
It’s default is usually & but it can be changed to something else.

That would cause your particular settings to think : (if that’s what
define is set to) is the indicator of a variable.

In SQL Plus, you would simply do “show define”

I’m not sure where that setting would be changed in Toad. I’ve never
altered it myself so I’ve never gone looking. Something that could alter
it for you would be a login script changing the setting.

Roger S.