D
Dale Fye
I am trying to query a table that is linked from an Oracle database for
records where the [TimeStamp] field is greater than a particular value.
I have tried
Select * FROM myTable WHERE [TimeStamp] > #2/2/2006#
and
SELECT * FROM myTable WHERE [TimeStamp] > '2/2/2006'
But both of these queries return all the records in the table, which run
into the hundreds of thousands.
The TimeStamp field appears as m/d/yyyy hh:mm:ss AM/PM when viewed in the
linked table. Additionally, when I try to order the return recordset in the
query, it will not sort descending.
records where the [TimeStamp] field is greater than a particular value.
I have tried
Select * FROM myTable WHERE [TimeStamp] > #2/2/2006#
and
SELECT * FROM myTable WHERE [TimeStamp] > '2/2/2006'
But both of these queries return all the records in the table, which run
into the hundreds of thousands.
The TimeStamp field appears as m/d/yyyy hh:mm:ss AM/PM when viewed in the
linked table. Additionally, when I try to order the return recordset in the
query, it will not sort descending.