From: "Martin Dowie" <martin.dowie@btopenworld.com>
Subject: Re: Inserting Calendar.Time in a database
Date: Thu, 5 Aug 2004 21:19:07 +0000 (UTC)
Date: 2004-08-05T21:19:07+00:00 [thread overview]
Message-ID: <ceu88b$lo5$1@sparta.btinternet.com> (raw)
In-Reply-To: br8nmj3ulp8n$.1hmfh3p3izvj8$.dlg@40tude.net
Dmitry A. Kazakov wrote:
>> I need to insert some timestamps (type Ada.Calendar.Time) in a
>> database accessed via ODBC using gnade+gnat 3.15p.
>>
>> I've looked for timestamp support in the gnade sources without much
>> luck, I've specially checked the embedded sql support and I haven't
>> found nothing for this purpose.
>>
>> I'm completely clueless about the ODBC client packages so if someone
>> has done this before (with gesql or directly), a quick pointer for
>> the things to look at would be great.
>
> The problem is that Ada.Calendar.Time is a political time, while
> persistent time stamps should be UTC or any other absolute time. I
> know no OS-independent solution for that.
Ada.Calendar.Time_Zones might be of use to you. You could store
the value as a string (Ada.Calendar.Formatting).
See http://www.martin.dowie.btinternet.co.uk/
Cheers
-- Martin
next prev parent reply other threads:[~2004-08-05 21:19 UTC|newest]
Thread overview: 41+ messages / expand[flat|nested] mbox.gz Atom feed top
2004-08-05 13:44 Inserting Calendar.Time in a database Jano
2004-08-05 15:21 ` Dmitry A. Kazakov
2004-08-05 21:19 ` Martin Dowie [this message]
2004-08-06 6:31 ` Jano
2004-08-06 11:32 ` Peter Hermann
2004-08-06 11:40 ` Duncan Sands
2004-08-08 11:10 ` Jano
2004-08-06 7:48 ` Dmitry A. Kazakov
2004-08-06 9:28 ` Martin Dowie
2004-08-06 10:44 ` Dmitry A. Kazakov
2004-08-07 9:50 ` Martin Dowie
2004-08-07 20:32 ` Dmitry A. Kazakov
2004-08-08 8:35 ` Martin Dowie
2004-08-08 11:03 ` Simon Wright
2004-08-09 7:46 ` Dmitry A. Kazakov
2004-08-09 17:54 ` Nick Roberts
2004-08-10 7:33 ` Dmitry A. Kazakov
2004-08-10 8:36 ` John B. Matthews
2004-08-10 18:51 ` Nick Roberts
2004-08-11 1:14 ` John B. Matthews
2004-08-19 4:10 ` Jano
2004-08-19 4:10 ` Jano
2004-08-09 11:52 ` Frank J. Lhota
2004-08-08 10:46 ` Simon Wright
2004-08-09 8:02 ` Dmitry A. Kazakov
2004-08-24 19:25 ` Randy Brukardt
2004-08-25 7:24 ` Dmitry A. Kazakov
2004-08-25 8:18 ` Martin Dowie
2004-08-25 9:25 ` Dmitry A. Kazakov
2004-08-25 9:42 ` Martin Dowie
2004-08-26 5:26 ` Simon Wright
2004-08-26 0:49 ` Randy Brukardt
2004-08-26 9:30 ` Dmitry A. Kazakov
2004-08-26 10:11 ` Martin Dowie
2004-08-26 10:58 ` Dmitry A. Kazakov
2004-08-26 12:32 ` Martin Dowie
2004-08-26 16:26 ` Dmitry A. Kazakov
2004-08-26 17:23 ` Martin Dowie
2004-08-26 18:55 ` Randy Brukardt
2004-08-26 20:04 ` Dmitry A. Kazakov
2004-08-26 5:22 ` Simon Wright
replies disabled
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox