Hi,

I'm  working for to adapt the firebird backend module [1] for django 1.2 which use kinterbasdb driver.

I've  a problem running the test suite for django, against firebird 2.1. When try to execute the next query

SELECT FIRST 1 (1) AS "A" FROM "MODEL_FORMS_POST" WHERE (EXTRACT(DAY FROM "MODEL_FORMS_POST"."POSTED") = ? AND "MODEL_FORMS_POST"."POSTED" BETWEEN ? and ? AND EXTRACT(MONTH FROM "MODEL_FORMS_POST"."POSTED") = ? AND "MODEL_FORMS_POST"."TITLE" = ? )

with the next params:

(3, '2008-01-01 00:00:00', '2008-12-31 23:59:59.999999', 9, u'Django 1.0 is released')

I get a sql error:

  Dynamic SQL Error
  SQL error code = -303
  conversion error from string "2008-12-31 23:59:59.9999"

Pay attention to param 3 into the param tuple. Internally, the django-firebird backend translate the 2008-12-31 23:59:59.999999, for adapt to firebird requeriment of 4 digits. The sql error message show the correct param value.

What am I doing wrong ?
Why I get that error ?

Any help will be apreciated.

Thanks in advance.
---
maxi.

[1] http://code.google.com/p/django-firebird/