[SQLObject] DateTimeCol with microsecond resolution.

[Ben T. <bt...@gm...>]

I really need to store date/time values with millisecond resolution.
What would be the easiest way to achieve this? I found the following
patch:

http://permalink.gmane.org/gmane.comp.python.sqlobject/5106

But I am loath to apply a patch to SQLObject since my code must be portable.

Must I create my own column type? Is there any way to override the
storage method of DateTimeCol? I tried passing a datetimeFormat to the
DateTimeCol.__init__() but this did not have the desired effect. I am
assuming the TIMESTAMP data type of sqlite does not support this level
of resolution? If so, I suppose I must store the date as a string in
ISO 8601 format?

Thanks.