I have the following query (see attached file) running against an Oracle database that is not returning any records but should be.
The only thing I can think of is that the date format in the database is "6/1/2008 7:00:52 AM" and I am looking for just "6/1/2008".
Is there a way to do the date as a wildcard? I tried "6/1/2008%" with no luck.
Any help would be appreciated.