Posterous theme by Cory Watilo

Inteligens dizájn

Epic Epoch Fail

I shit you not:

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.