Wow, iPhoto’09 is even worse. Photo times are stored as decimal days since Jan 1, 2000 UTC. So, here’s what I used to get a human-readable time out of my little test database:
sqlite> select photoDate, datetime((photoDate + julianday(‘2000-01-01′) – 2440587.5)*86400.0,’unixepoch’,’localtime’) from SqPhotoInfo;
It actually only took me a few minutes to reverse engineer because I’ve noticed that whenever Apple stores a date as a float, it’s almost always Julian days or something related. And I’m used to working with Julian days from my years as an astronomer.