ORACLE syntax for querying dates
Posted on 2011-10-11
I am using a linked server on SQL 2005 to Oracle, Im using the openquery command to return a select query
I have a time date stamp field and want to return records with in a date and time range
so far I have
SELECT * FROM ORACLE.DB WHERE TO_DATE(ENTRY_DATE,'YYYY-MM-DD HH24:MI:SS) >=
TO_DATE('2011-10-10 00:00:01') AND TO_DATE(ENTRY_DATE,'YYYY-MM-DD HH24:MI:SS) <= TO_DATE('2011-10-11 15:00:00')
Although there are records in the table none are being returned, does anyone know why this could be, any help would be great beacuse Im not upto speed with my Oracle syntax knowledge!