Fixing bad timestamps

[Dan Smith]

I've maintained a single gnucash database for 3-4 years.  During that time, I've lived in different U.S. time zones.  As a result, the dates on my transactions seem to have been recorded with different UTC offsets -- I can tell because, now that I'm in Pacific time, many of the transactions are displayed with the wrong dates: 1/1/2010, recorded in EST, is interpreted as 12/31/2009 when running in PST.

This is a known (old) bug: https://bugzilla.gnome.org/show_bug.cgi?id=137017

What are my best options for working around the problem?

- In the past, I forced GNUCash to run in EST, via an environment variable set in a launcher script.  But it's not clear to me how to do this with the latest OS X binary, now that it's all bundled up in an application.

- I'm using the old file format.  Would it help to migrate to an SQL database?

- Is there a script (existing or something that would be easy to write up) that would allow me to "normalize" my timestamps in my data file?

Any other suggestions?

--Dan