[obdgpslogger] How to read the date time field in the obd databases

[Robert Konigsberg]

Gary always said it was dead simple, I just didn't believe him. I do now.

In python: datetime.datetime.fromtimestamp(value).

In sqlite: datetime(timestamp, 'unixepoch', 'localtime')

e.g. select start, datetime(start, 'unixepoch', 'localtime') from trip;

Gah. Gary care to update some document somewhere? As a favor? Pleeeease?

Thanks -Rob

-- 
Robert Konigsberg
konigsberg at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://icculus.org/pipermail/obdgpslogger/attachments/20110101/01f44ac8/attachment.htm>