Re: kniterbasdb and datetime

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 = "UPDA

Re: kniterbasdb and datetime

>> 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, T

Re: kniterbasdb and datetime

DarkBlue írta: > On Dec 13, 7:45 pm, Laszlo Nagy <[EMAIL PROTECTED]> wrote: > >> Hi All, >> >> I connected to a FireBird 1.5 database this way: >> >> import kinterbasdb >> kinterbasdb.init(type_conv=200) # >> Seehttp://kinterbasdb.sourceforge.net/dist_docs/usage.html#faq_fep_is_mx... >> >> Th

Re: kniterbasdb and datetime

On Dec 13, 7:45 pm, Laszlo Nagy <[EMAIL PROTECTED]> wrote: > Hi All, > > I connected to a FireBird 1.5 database this way: > > import kinterbasdb > kinterbasdb.init(type_conv=200) # > Seehttp://kinterbasdb.sourceforge.net/dist_docs/usage.html#faq_fep_is_mx... > > Then I try to update the database

kniterbasdb and datetime

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 = ?" para