From mboxrd@z Thu Jan 1 00:00:00 1970 X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me X-Spam-Level: X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00 autolearn=ham autolearn_force=no version=3.4.4 X-Google-Thread: 103376,e686c2c95beefb1c X-Google-Attributes: gid103376,public X-Google-Language: ENGLISH,ASCII-7-bit Path: g2news1.google.com!news1.google.com!news.glorb.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!cyclone1.gnilink.net!gnilink.net!cyclone.southeast.rr.com!news-server.columbus.rr.com!fe2.columbus.rr.com.POSTED!not-for-mail From: "John B. Matthews" Newsgroups: comp.lang.ada Subject: Re: Inserting Calendar.Time in a database References: <1jgik0ntrex36$.1pyha1husddpe.dlg@40tude.net> <41134e18$1_1@baen1673807.greenlnk.net> <94tir0ejn3n4$.a7o1lv87loha$.dlg@40tude.net> <13x45njobjvn3.yhisk87dws3.dlg@40tude.net> <1j730n9o2lgav$.rvhdl0zjqvnw$.dlg@40tude.net> User-Agent: MT-NewsWatcher/3.3b1 (PPC Mac OS X) Message-ID: Date: Tue, 10 Aug 2004 08:36:44 GMT NNTP-Posting-Host: 65.31.62.213 X-Complaints-To: abuse@rr.com X-Trace: fe2.columbus.rr.com 1092127004 65.31.62.213 (Tue, 10 Aug 2004 04:36:44 EDT) NNTP-Posting-Date: Tue, 10 Aug 2004 04:36:44 EDT Organization: Road Runner High Speed Online http://www.rr.com Xref: g2news1.google.com comp.lang.ada:2647 Date: 2004-08-10T08:36:44+00:00 List-Id: In article , "Nick Roberts" wrote: > On Mon, 9 Aug 2004 09:46:20 +0200, Dmitry A. Kazakov > wrote: > > > On Sun, 8 Aug 2004 08:35:07 +0000 (UTC), Martin Dowie wrote: > > > >> "Dmitry A. Kazakov" wrote in message > >> news:13x45njobjvn3.yhisk87dws3.dlg@40tude.net... > > > >>> 3. Two clock readings are not unique > > > >> ??? > > > > It is not warranted that Clock /= Clock. > > This isn't a spelling flame, but there is a horrible subtlety in the > English language here. > > I'm not certain, but I think the modern interpretation of the word > 'warranted' is to mean 'justified'. I think the word 'warranteed' must > be used to get the meaning 'guaranteed' (as I assume Dmitry intended). I am unable to verify this usage. Several sources include definitions that mention "written guarantee" and "supported by authority or proof." A "warrantee" is a written guarantee, or the person to whom a warrant or guarantee is given. I am unable to find a definition for the word "warranteed;" it appears to be a term of art in the advertising industry. I would say that Dmitry's usage is correct, if not entirely idiomatic. Does the OP's database support conversion with a format mask? For example, assuming a fuction that converts a Time to a formatted String, tell the database what format to use: DT_String := To_String(Clock); ... insert into values (..., TO_DATE(:DT_String,'YYYY-MM-DD hh:mi:ss'), ...); I understand this is non-portable. John ---- jmatthews at wright dot edu www dot wright dot edu/~john.matthews/