Okay, now that's more like it: umask 022 && unset LC_ALL && LANG=en_US.UTF-8 export LANG && db=/var/lib/dbconfig-common/sqlite3/mailman3-web/mailman3web.db && sqlite3 "$db" 'select * from hyperkitty_email where mailinglist_id = 6 and ( id = 2049 or id = 2050 );' 2049|E1sgLtT-00053o-Vq@balug-sf-lug-v2.balug.org|WGCC6FP62GP62TRONFLNQ5WYAYHD7NIM|[BALUG-Test] test - ignore db timezone testing|db timezone testing 2024-08-20T10:15:15+00:00 Tue, 20 Aug 2024 10:15:15 +0000 Tue Aug 20 10:15:15 2024 2024-08-20T03:15:15-07:00 Tue, 20 Aug 2024 03:15:15 -0700 Tue Aug 20 03:15:15 2024|2024-08-20 10:15:15|0||2024-08-20 10:15:19.221496|0||mpaoli@balug.org|1199|Michael Paoli|6| 2050|CAPU_E+caPH_TP4np7Oki2bcFmgqmhW0_6=cejRaubZf1HrSm-A@mail.gmail.com|WAZBQUTBQRGZIHDJUBGVNKQHBYPTZ6TL|[BALUG-Test] test - ignore - db timezone testing|db timezone testing 2024-08-20T10:15:15+00:00 Tue, 20 Aug 2024 10:15:15 +0000 Tue Aug 20 10:15:15 2024 2024-08-20T03:15:15-07:00 Tue, 20 Aug 2024 03:15:15 -0700 Tue Aug 20 03:15:15 2024|2024-08-20 10:15:26|-420||2024-08-20 10:16:12.677063|0||michael.paoli@berkeley.edu|1200|Michael Paoli|6|
So, the fields date and timezone that go into the database, looks like date is absolute, (presumably) relative UTC, and timezone is what's determined from Date: header. So essentially from Date: header, it figures out date (timestamp) (relative to UTC) and records that, and also figures out timezone (offset in minutes relative UTC) and records that for timezone. Kind'a what I was more-or-less guessing to be the case - but wanted to be sure. Notably useful/relevant/important, for, e.g. taking relevant db dump, and converting that back to a useable mbox format (won't have all the original, but is better and closer to original than hyperkitty's download capability - which if nothing else adds some @ --> (a) obfuscation, among other issue(s).
Michael Paoli wrote:
db timezone testing 2024-08-20T10:15:15+00:00 Tue, 20 Aug 2024 10:15:15 +0000 Tue Aug 20 10:15:15 2024 2024-08-20T03:15:15-07:00 Tue, 20 Aug 2024 03:15:15 -0700 Tue Aug 20 03:15:15 2024