[pysqlite] Timestamp adapter and timezone

Adrian Klaver <[email protected]> Tue, 10 Mar 2009 16:42:56 -0700

Newsgroups	gmane.comp.python.db.pysqlite.user
Message-ID	<[email protected]>

Recently ran across a problem with moving a timestamp with timezone value from 
Postgres to sqlite. Seems the convert_timestamp function does not know what to 
do with the offset value. See below:

File "/usr/lib/python2.5/sqlite3/dbapi2.py", line 71, in convert_timestamp
    microseconds = int(float("0." + timepart_full[1]) * 1000000)
ValueError: invalid literal for float(): 0.610000-08:00

Any suggestions are welcome.

Thanks,
-- 
Adrian Klaver
[email protected]