Public
- Public
- Network
- Groups
- Featured
- Popular
- People

Screenshot of a SQL query retrieving iPhoto’s metadata for the make and model of every camera used in a library, the total number of photos taken with it, and the timestamps of the first and most recent photos taken with each camera. SELECT za.ZCAMERAMAKE as make, za.ZCAMERAMODEL as model, ROUND(za.ZDATECREATED) + 978307260 as date FROM ZEXTENDEDATTRIBUTES za WHERE model NOT NULL

Download link

Screenshot of a SQL query retrieving iPhoto’s metadata for the make and model of every camera used in a library, the total number of photos taken with it, and the timestamps of the first and most recent photos taken with each camera. SELECT za.ZCAMERAMAKE as make, za.ZCAMERAMODEL as model, ROUND(za.ZDATECREATED) + 978307260 as date FROM ZEXTENDEDATTRIBUTES za WHERE model NOT NULL
https://sb-0zfmbqf4l5.b-cdn.net/media_attachments/files/112/264/856/739/634/155/original/171892970a17e9ad.png

Notices where this attachment appears

Embed this notice
Eaton (eaton@phire.place)'s status on Sunday, 14-Apr-2024 01:29:47 JST Eaton
in reply to

For the *exceptionally* nerdy, this also makes it easy to figure out when you changed phones…

In conversation about a year ago from phire.place permalink