Syntax error - not a valid month when using SQL Plus
594752Oct 11 2007 — edited Oct 11 2007I have a tool called Golden32 in which I have used this statement and it works flawlessly:
select count(*) from rco.rate_route where mdfy_dt >= '09/27/2007';
I do some of my work in SQL Plus. The above statement gives me the error of ORA-01843 'not a valid month' and it points to the first ' in '09/27/2007'.
Any ideas what is going on? I need to be able to do it here in SQL Plus because if I don't get the results I want, I am going to issue a rollback.
Thank you.
P.S. I tired it without the quotes and with double quotes.