[Davical-general] Unify TimeZones in Postgresql-DB

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

[Davical-general] Unify TimeZones in Postgresql-DB

Dear all

After successfully upgrading to latest davical, I run into the problem
with Tunderbird/Lightning of a series of -- very old entries with --
unknown timezones.

Can anybody provide me a psql-statement that I can use to set all
timezone entries to "Europe/Zurich"?

I know, it would be possible to dump the DB, run 'sed' and then
recreate.  However, I do not like the idea to run that procedures.

Thank you.

Best regards

Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
Davical-general mailing list
[hidden email]