From: "Dmitry A. Kazakov" <mailbox@dmitry-kazakov.de>
Subject: Re: GNATCOLL SQLite3 vs Ada.Calendar.Time
Date: Thu, 18 Aug 2016 10:09:24 +0200
Date: 2016-08-18T10:09:24+02:00 [thread overview]
Message-ID: <np3qgr$1qee$1@gioia.aioe.org> (raw)
In-Reply-To: fa1918c3-32cc-4203-bfad-55f26646305f@googlegroups.com
On 17/08/2016 23:05, Stephen Leake wrote:
> One solution would be to replace the "DATETIME" field type in the
> .sql file with "TEXT", always pass strings for times, and rely on
> lexicographic sorting for time comparison. But that seems extreme.
AFAIK SQLite3 does not have date/time types. DATETIME is NUMERIC
according to:
https://www.sqlite.org/datatype3.html
> Any ideas what's going on here?
I would say, never rely on built-in DB types conversions.
--
Regards,
Dmitry A. Kazakov
http://www.dmitry-kazakov.de
next prev parent reply other threads:[~2016-08-18 8:09 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 [this message]
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
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