Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.sys.mac.system > #117778

Re: SQLite tools on OS-X

Path csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From Jolly Roger <jollyroger@pobox.com>
Newsgroups comp.sys.mac.system
Subject Re: SQLite tools on OS-X
Date 20 Aug 2018 19:12:27 GMT
Organization People for the Ethical Treatment of Pirates
Lines 32
Message-ID <fu0i4rFsoa2U1@mid.individual.net> (permalink)
References <WGCeD.61639$1E6.58979@fx07.iad>
X-Trace individual.net E3Zahq2CIs2KryybI0mKcgG75v2azuAjKnGsuhdyDq/QDFl9T6
Cancel-Lock sha1:As+J42sIpRYJpqMSSmrvKjkcyjk=
X-No-Archive Yes
MMail-Copies-To nobody
X-Face _.g>n!a$f3/H3jA]>9pN55*5<`}Tud57>1<n@LQ!aZ7vLO_nWbK~@T'XIS0,oAJcU.qLM dk/j8Udo?O"o9B9Jyx+ez2:B<nx(k3EdHnTvB]'eoVaR495,Rv~/vPa[e^JI+^h5Zk*i`Q;ezqDW< ZFs6kmAJWZjOH\8[$$7jm,Ogw3C_%QM'|H6nygNGhhl+@}n30Nz(^vWo@h>Y%b|b-Y~()~\t,LZ3e up1/bO{=-)
User-Agent slrn/1.0.1 (Darwin)
Xref csiph.com comp.sys.mac.system:117778

Show key headers only | View raw

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

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