[x] Add column and migrate old data via DDL on startup. It should add a "timestamp" column in sqlite but thats just a string really.
It DOES perform TZ normalization of the timestamp of past data, which may be user-input offset
It cannot produce a normalized timestamp above nanosecond precision so in the migration script for sqlite the zeroes are wedged in. In Postgres it sticks to 6 decimal places universally.
[x] For all new records it normalizes both timestamp and stored exactly the same way, and modifies the existing util fn/macro to allow for offset inputs in timestamp which has not been needed before.
[x] Add column and migrate old data via DDL on startup. It should add a "timestamp" column in sqlite but thats just a string really.
It DOES perform TZ normalization of the timestamp of past data, which may be user-input offset
It cannot produce a normalized timestamp above nanosecond precision so in the migration script for sqlite the zeroes are wedged in. In Postgres it sticks to 6 decimal places universally.
[x] For all new records it normalizes both timestamp and stored exactly the same way, and modifies the existing util fn/macro to allow for offset inputs in timestamp which has not been needed before.