Please Help: Dates in Oracle

From: Mike <makonnen_at_vt.edu>
Date: 1997/12/17
Message-ID: <6792li$rmi$1@solaris.cc.vt.edu>#1/1

Hello,

I'm trying to write a SQL Passthrough query to an Oracle database in access. I seem to be having trouble querying by a date field. Here's my entire SQL statement:

SELECT *
FROM HREI.DEPARTMENT_CODE
WHERE EXTRACT_DATE = #12/13/97#; HREI.DEPARTMENT_CODE is the table

EXTRACT_DATE is a field containing date formatting like this: 10/4/97

I've played arround with other fields in the database and I can query fine. It's with the date field that I'm having problems. Am I using the "#" signs correctly?

Any help would be much appreciated. Thanks

Mike. Received on Wed Dec 17 1997 - 00:00:00 CST