Database experiences in Python: Good or Bad?

Daniel Dittmar daniel.dittmar at
Wed Aug 14 09:52:01 EDT 2002

Brad Clements wrote:
> What's killing me today is that sapdbapi doesn't represent
> times/dates as class objects, like I got with gvibDA.. I have a lot
> of XSLT code that uses xml_pickle objects.. and a pickled timestamp
> from gvib doesn't look anything like that from SAP.
> In fact, SAP timestamps are 20 character strings.. really ugly.

It is easy to register conversion callbacks with sapdbapi.

- write conversion functions from the SAP DB values to any
object/representation you like
- create a dictionary which maps the SAP DB type names 'Date', 'Time',
'Timestamp' to those functions
- connection.setTypeTranslation (conversionMapping)

see the end of for examples like converting to module time


Daniel Dittmar
SAP DB, SAP Labs Berlin

More information about the Python-list mailing list