MSAccess pass-through query to Oracle ODBC
I connected to an ORACLE ODBC using MS Access. I am creating pass-through queries in MS Access. I understand that the SQL used in MS Access is different from ORACLE SQL. All I want my query to due is return rows that are within a certain date range. This is my current SQL code:
SELECT PLAZA_ID, PLAZA_DESCR, UPDATE_TIMESTAMP
FROM PLAZA WHERE UPDATE_TIMESTAMP BETWEEN DATE '2007-05-12 09:00:00' AND DATE '2007-06-12 12:00:00'
I get the following error:
[Oracle][ODBC][RBD]%SQL-F-CONERR, Data connection error for string '2007-05-12 09:00:00' -COSI-F-IVTIME, invalid date or time (#-1)
My documentation states that the UPDATE_TIMESTAMP field is of the datatype DATE VMS.
Someone please help.
Julio Cesar
-"Bueller.......... Bueller.......... Bueller.......... Bueller.........."
__________________
Julio Cesar
-\"Bueller.......... Bueller.......... Bueller.......... Bueller..........\"
|
