From: "Dmitry A. Kazakov" <mailbox@dmitry-kazakov.de>
Subject: Re: GNATCOLL SQLite3 vs Ada.Calendar.Time
Date: Thu, 18 Aug 2016 21:48:25 +0200
Date: 2016-08-18T21:48:25+02:00 [thread overview]
Message-ID: <np53eg$1o71$1@gioia.aioe.org> (raw)
In-Reply-To: np4uok$old$1@dont-email.me
On 2016-08-18 20:28, Jeffrey R. Carter wrote:
> I would guess that, since you used strings to insert the datetime values, SQLite
> is using TEXT representation for them.
No, SQLite3 uses NUMERIC which is INTEGER or REAL at SQLite's choice
when the conversion is reversible. Otherwise it is up to 15 decimal
points of precision which is not enough for 64-bit time stamps.
When storing timestamps into SQLite3 it is better to use TEXT and some
custom time/string conversion that would guarantee proper ordering and
precision.
> Also that "+" applied to an
> Ada.Calendar.Time is producing a non-string result (numeric?) and SQLite has
> problems dealing with the combination. Or something.
That depends on how GNATCOLL treats bound parameters. I am not familiar
with it.
--
Regards,
Dmitry A. Kazakov
http://www.dmitry-kazakov.de
next prev parent reply other threads:[~2016-08-18 19:48 UTC|newest]
Thread overview: 11+ messages / expand[flat|nested] mbox.gz Atom feed top
2016-08-17 21:05 GNATCOLL SQLite3 vs Ada.Calendar.Time Stephen Leake
2016-08-18 8:09 ` Dmitry A. Kazakov
2016-08-18 11:19 ` G.B.
2016-08-18 17:45 ` Stephen Leake
2016-08-18 18:13 ` Stephen Leake
2016-08-19 15:30 ` Stephen Leake
2016-08-19 17:43 ` G.B.
2016-08-18 18:28 ` Jeffrey R. Carter
2016-08-18 19:48 ` Dmitry A. Kazakov [this message]
2016-08-18 20:50 ` Jeffrey R. Carter
2016-08-18 22:05 ` Randy Brukardt
replies disabled
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox