Report post #3 in Sensor readings doubled up for an hour at the clock change
Rowid is still insertion order for me, so that works. Did the conversion with a script that walks in rowid order, and I've kept the old column around in case.
Programming discussion