CAST Gives ORA 00905 Missing Keyword Error
279639Mar 11 2004 — edited Dec 7 2004Hi:
We have two machines here for testing Oracle.
On one machine we have version 9.0.1.1.1 and on
the other machine we have version 9.2.0.4.0
We are trying to run this statement on both machines:
SELECT CAST('2004-01-01' AS DATE) AS Test FROM dual;
On the first machine (9.0) this works fine, but on
the second machine (9.2) it gives the missing keyword error.
Any ideas as to why it doesn't work on the second machine?
TIA,
Doug.