SQL View Garbles Date-Time Criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Access 2000, I was querying in Design View against a linked Oracle table
via ODBC and a date-time field with the following criteria:

Like #3/2/2004 12:00:00 PM#

When viewing the query in SQL View, however, the following appeared:

Like #3/2/2004 12:0:0#

The query didn't run properly, of course. Has anyone seen this problem
before, and can it be corrected?
 
Wolfie,
I do not have an answer, but I do have a question to your question, if you
don't mind:
I did not know Access could link directly to an Oracle table. Can you give
me some more information?
PattyD
 
Back
Top