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

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

Re: SQLite tools on OS-X

Subject Re: SQLite tools on OS-X
Newsgroups comp.sys.mac.system
References <WGCeD.61639$1E6.58979@fx07.iad> <slrnpnrtsq.133b.g.kreme@jaka.lan>
From JF Mezei <jfmezei.spamnot@vaxination.ca>
Message-ID <HlofD.7802$Ac3.5580@fx45.iad> (permalink)
Date 2018-08-22 21:46 -0400

Show all headers | View raw

On 2018-08-22 19:54, Lewis wrote:

>> The field was created as :
> 
> You should not be creating a table in an existing database.
> 
>> ZDATE TIMESTAMP,

.schema lists how a table was created. I didn't create the database or
try to modify it. Apple created it for the iPhone defining a field as
"TIMESTAMP" which the SQLITE3 utility didn't process correctly. (and
which the sqlite documentation doesn't know about).


Mr Empson did the research and provided the information on the Apple
timestamp format (number of seconds since Jan 1 2000)

At the time I asked the question, i was unaware that Apple provided the
sqlite3 utility on OS-X, thought it used sqlite on OS-X and IOS as
run-time only libraries.

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