[icq-devel] Timestamps in db
goran at roseen.se
Tue Jan 13 10:29:12 CET 2004
I know we mostly discuss the protocol here, but since the list has been so
silent lately, I dare ask a question regarding the database files.
I have written an app that gathers old messages from saved db files. I
don't know if my copy of the specs was the most recent available, but
anyway I had no problem getting the parsing and extraction to work.
As everyone knows, for each message there is a timestamp. This timestamp is
the GMT time (and date) of the event, which is nice because if sender and
receiver are in different timezones, the GMT time will be the same for
both. And I can see in my contacts which timezone someone belongs to.
My problem was this; I can only see general timezones, not the actual
difference between local time and GMT. And Daylight Savings Time can make
this difference change.
Sure, I can have a list of all dates in the past when we have changed
between winter and summer time, and manually adjust the dates, but that is
an ugly solution.
Also, if I don´t keep a record of every contrys history of DST changes, I
can never see what the local time was for a person when that person sent me
Does I overlook something here? Is there something in the DB that I don't
Outgoing mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.209 / Virus Database: 261.6.1 - Release Date: 2004-01-08
More information about the icq-devel