Timestamp error

[pflick]

I am trying to select rows using timestamp criteria in the where clause using 
the jdbc embedded driver (10.3.2.1) but  I get the following error:

SELECT * FROM mytable WHERE downloaded_dtm >= timestamp('2000-01-01 00:00:00') 
and downloaded_dtm < timestamp('2009-01-01 00:00:00')
java.sql.SQLException: Column '0' not found.
        at 
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown 
Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown 
Source)
        at org.apache.derby.impl.jdbc.ConnectionChild.newSQLException(Unknown 
Source)
        at org.apache.derby.impl.jdbc.EmbedResultSet.getColumn(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedResultSet.getString(Unknown Source)

Any help would be appreciated.

       
---------------------------------
Never miss a thing.   Make Yahoo your homepage.