kniterbasdb and datetime

[Laszlo Nagy]

>> Kinterbasdb probably expects the format looking like
>>
>> month/day/year
>>
>> rather than
>>
>> year-month-day
>>     
All right, I tried the month/day/year version:

print sql
print params
cur.execute(sql,params)

Results in:

Inserting new TTT codes...insert into ttt(

        ID,
        TTT,
        KIHIR
        ) VALUES (
    GEN_ID(G_TTT,1),
    ?,?)
[210227753, '11/1/2007']
Traceback (most recent call last):
  File "c:\Delphi5_Brinkman\Projects\TTTImport\tttupdate.py", line 131, 
in <module>
    cur.execute(sql,params)
kinterbasdb.ProgrammingError: (-413, 'isc_dsql_execute: \n  conversion 
error from string "2007-11-01"')


You see, I passed '11/1/2007' but the error says "2007-11-01". So what?

I also tried this:


Inserting new TTT codes...insert into ttt(

        ID,
        TTT,
        KIHIR
        ) VALUES (
    GEN_ID(G_TTT,1),
    ?, cast( ? as date) )
[210227753, '11/1/2007']

Results in:


Traceback (most recent call last):
  File "c:\Delphi5_Brinkman\Projects\TTTImport\tttupdate.py", line 131, 
in <modu
le>
    cur.execute(sql,params)
kinterbasdb.ProgrammingError: (-804, 'isc_dsql_prepare: \n  Dynamic SQL 
Error\n
 SQL error code = -804\n  Data type unknown')

Right now I cannot see any way to specify a date parameter and as time 
goes by, it is becoming a biger problem for me. :-(

Please help.

    Laszlo