BIRT Date Parameters for Informix Queries -

I try to use a date parameter in a query against an infraform (11.50) database, a wall of syntax errors I am walking in I am using this query:

  Choose from a few populations where SOMEDATETIME & gt; From day to day (?) Minutes and SOMEDATETIME & lt; Date time (2014-10-30) year-to-day  

The query parameter type is set to the date and the report parameter is set to date time, in the form of a short date Has been formatted.

The error I get is: java.sql.SQLException: non-numeric characters in the data-time or interval.

If I comment where from, then I can get the Birit to show me the value that is interpolished with it: 2014-10-27 00:00 .

As far as I can tell, this is an appropriate formatting for an Infomercial Datime Limitic. I am starting to start what I have lost in my mind ...

Edit:

It seems that my inexperience The combination of Informix and my environment, I am preparing and testing my questions with esquirell using JDBC configurations similar to BRTT I day-time (YYYY-MM-DD) year

In esquire, I am getting syntax errors I do not if I true nature of time as long as use. in the right direction. The job of cutting YYYY-MM-DD is literally just below the query within BIRT.

I am feeling that there is something with it that how SQUIRELOR is establishing it is a session with the database, but enough for the report is bad for it.

I do not think insert it into the datatome using the prepared statement parameter.

My quick jyothon script shows that datetime (for the second year) you can use something like:

  pstm = db .prepareStatement ("SELECT * FROM _d_test WHERE dt & gt;?") Pstm.setString (1, "2010-01-01 00:00:00")  

and With date (YEAR to DAY) you can use something like this:

  pstm = db.prepareStatement ("SELECT * FROM _d_test WHERE d"? ") Pstm .setstring (1," 2010-01-01 ")