Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.sys.mac.system > #117778
| From | Jolly Roger <jollyroger@pobox.com> |
|---|---|
| Newsgroups | comp.sys.mac.system |
| Subject | Re: SQLite tools on OS-X |
| Date | 2018-08-20 19:12 +0000 |
| Organization | People for the Ethical Treatment of Pirates |
| Message-ID | <fu0i4rFsoa2U1@mid.individual.net> (permalink) |
| References | <WGCeD.61639$1E6.58979@fx07.iad> |
On 2018-08-20, JF Mezei <jfmezei.spamnot@vaxination.ca> wrote: > I found the iPhone call log, it is an SQLite database. Yes it's at: HomeDomain: Library/CallHistoryDB/CallHistory.storedata Filename: 5a4935c78a5255723f707230a451d79c540d2741 > I downloaded the SQLlite tools from an sqlite web site, which includes > the sqlite3 program. It lets one create , select, and export data. No need for that since macOS comes with sqlite3. > The problem is that Apple uses a "julian date" real number for the > date/time of a phone call and the documented > > select datefile(ZDATE) from ZCALLRECORD ; yields a bunch of blank lines. Shouldn't that be: select datetime(ZDATE)? I get blanks too. I also tried it with datetime(ZDATE, 'unixepoch') and got incorrect timestamps. > The documentation states that julian date time (a real number) is the > 12th acceptable format for the date/time routines. I'm not sure these are actually Juian dates. -- E-mail sent to this address may be devoured by my ravenous SPAM filter. I often ignore posts from Google. Use a real news client instead. JR
Back to comp.sys.mac.system | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
SQLite tools on OS-X JF Mezei <jfmezei.spamnot@vaxination.ca> - 2018-08-20 13:15 -0400
Re: SQLite tools on OS-X nospam <nospam@nospam.invalid> - 2018-08-20 13:33 -0400
Re: SQLite tools on OS-X Tim Streater <timstreater@greenbee.net> - 2018-08-20 18:42 +0100
Re: SQLite tools on OS-X nospam <nospam@nospam.invalid> - 2018-08-20 13:46 -0400
Re: SQLite tools on OS-X Tim Streater <timstreater@greenbee.net> - 2018-08-20 22:15 +0100
Re: SQLite tools on OS-X Jolly Roger <jollyroger@pobox.com> - 2018-08-20 22:44 +0000
Re: SQLite tools on OS-X Lewis <g.kreme@gmail.com.dontsendmecopies> - 2018-08-22 23:56 +0000
Re: SQLite tools on OS-X Jolly Roger <jollyroger@pobox.com> - 2018-08-20 19:12 +0000
Re: SQLite tools on OS-X dempson@actrix.gen.nz (David Empson) - 2018-08-21 13:57 +1200
Re: SQLite tools on OS-X JF Mezei <jfmezei.spamnot@vaxination.ca> - 2018-08-20 23:26 -0400
Re: SQLite tools on OS-X Tim Streater <timstreater@greenbee.net> - 2018-08-21 09:02 +0100
Re: SQLite tools on OS-X dempson@actrix.gen.nz (David Empson) - 2018-08-21 22:10 +1200
Re: SQLite tools on OS-X Lewis <g.kreme@gmail.com.dontsendmecopies> - 2018-08-22 23:54 +0000
Re: SQLite tools on OS-X JF Mezei <jfmezei.spamnot@vaxination.ca> - 2018-08-22 21:46 -0400
Re: SQLite tools on OS-X Lewis <g.kreme@gmail.com.dontsendmecopies> - 2018-08-24 05:15 +0000
csiph-web