In the SQLite database in which Apple stores your iPhone text messages, each record has, among other things, a numeric field called 'date'.
If the message in question is an SMS, then that's what you'd expect: the number of seconds since the Unix Epoch, 1-Jan-1970 GMT. But if the message is an MMS or an iMessage, then it's the number of seconds since 1-Jan-2001 GMT. Same field. Same database. All interleaved.
$h->{date} += 978307200 if ($h->{is_madrid});
There is no emoticon for the feeling that I am having right now.























