parameter style description 'qmarkquestion mark style where each in the query is replaced by successive items in sequence for examplecur execute(where name=and account=?"(symbolaccount)the parameters are specified as tuple numeric style where : is filled in with the parameter value at index for examplecur execute(where name=: and account=: ",(symbolaccount)named style where :name is filled in with named value for this stylethe parameters must be given as mapping for examplecur execute(where name=:symbol and account=:account"{'symbol':symbol'account'account}printf-style format codes such as % %detc for examplecur execute(where name=% and account=% "(symbolaccount)python extended format codes such as %(name) similar to the 'namedstyle parameters must be specified as mapping instead of tuple 'numeric'named'format'pyformattype objects when working with database databuilt-in types such as integers and strings are usually mapped to an equivalent type in the database howeverfor datesbinary dataand other special typesdata management is more tricky to assist with this mappingdatabase modules implement set of constructor functions for creating objects of various types date(yearmonthdaycreates an object representing date time(hourminutesecondcreates an object representing time timestamp(yearmonthdayhourminutesecondcreates an object representing timestamp datefromticks(tickscreates date object from value of the system time ticks is the number of seconds as returned by function such as time time(timefromticks(tickscreates time object from value of the system time timestampfromticks(tickscreates timestamp object from value of the system time binary(screates binary object from byte-string lib fl ff