Hello All,
I have a table that is located in an oracle database. The table has a number of columns. I'm able to successfully connect to the database and query without any problems as long as I do not try to filter on a date column. But as soon as I try to say "where date >= '1/1/2010' (date can be anyting), the record set is empty. I know there should be records returned, but for some reason my date query is not working.
Any ideas would be greatly appreciated.
Example 1 (works no problem):
Example 2 (returns empty recordset):
One final thing is when I look at the properties of this column, the defined size is "16"
Thanks in advance.
I have a table that is located in an oracle database. The table has a number of columns. I'm able to successfully connect to the database and query without any problems as long as I do not try to filter on a date column. But as soon as I try to say "where date >= '1/1/2010' (date can be anyting), the record set is empty. I know there should be records returned, but for some reason my date query is not working.
Any ideas would be greatly appreciated.
Example 1 (works no problem):
Code:
str_sql = "select * from table"
rs.Open str_sql, con
Example 2 (returns empty recordset):
Code:
str_sql = "select * from table where startdate>='1/1/2010'"
rs.Open str_sql, con
One final thing is when I look at the properties of this column, the defined size is "16"
Thanks in advance.