kniterbasdb and datetime

[Uwe Grauer]

Laszlo Nagy wrote:
> 
>  Hi All,
> 
> I connected to a FireBird 1.5 database this way:
> 
> import kinterbasdb
> kinterbasdb.init(type_conv=200) # See
> http://kinterbasdb.sourceforge.net/dist_docs/usage.html#faq_fep_is_mxdatetime_required
> 
> 
> Then I try to update the database:
> 
> sql = "UPDATE TABLE1 SET DATEFIELD=? where ID = ?"
> params=[datetime.date(2007,11,01),2341]
> cursor.execute(sql,params)
> 
> I get this error:
> 
> kinterbasdb.ProgrammingError: (-413, 'isc_dsql_execute: \n  conversion
> error from string "2007-11-01"')
> 
> What is wrong here?
> 
> Thanks,
> 
>    Laszlo
> 

Just tested this against my 2.03 firebird db:

import datetime
import kinterbasdb as db

db.init(type_conv=200)
con = db.connect(dsn='myhost:fbtool-dev', user='sysdba', password='pwd')
sql = "update jnp set gebdat = ? where iid = ?"
params = [datetime.date(2007, 11, 01), 1000052]
cur = con.cursor()
cur.execute(sql,params)
con.commit()

It worked.
What version of kinterbasdb are you using?

Uwe