Hi guys and gals,
I have the following code:
strSQL="SELECT * FROM _EVENTS WHERE DATE_START LIKE '%JUN%'";
Statement stmt = conn.createStatement ();
rsPaging = stmt.executeQuery(strSQL);
It brings back 'No Results', however I know there is one record in the database that matches this criteria.
What I have tested thus far:
1) I have copied and pasted this code into SQL Plus WorkSheet and it executes like it supposed to and returns one record.
2) I have changed the field from DATE_START to TITLE and the values from %JUN% to %NET% and it brings back the record I am looking for. So the statement, connection, etc work
3) and just for kicks I also tried the following:
strSQL="SELECT * FROM _EVENTS WHERE TO_CHAR(DATE_START) LIKE '%JUN%'";
Statement stmt = conn.createStatement ();
rsPaging = stmt.executeQuery(strSQL);
and also a no-go.
So... in conclusion the statement seems to work fine, however, it seems to have problems with DATES? I am using Oracle 10g and the driver info is:
Jdbc Driver is : Oracle JDBC driver
Jdbc Driver Version is : 9.0.1.5.0
Thanks in advance!