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!news2.google.com!fu-berlin.de!uni-berlin.de!not-for-mail
From: "Nick Roberts" <nick.roberts@acm.org>
Newsgroups: comp.lang.ada
Subject: Re: Inserting Calendar.Time in a database
Date: Tue, 10 Aug 2004 19:51:07 +0100
Message-ID: <opsci5bhcgp4pfvb@bram-2>
References: <MPG.1b7c58269c53dcbc9897db@news.individual.net>
 <br8nmj3ulp8n$.1hmfh3p3izvj8$.dlg@40tude.net>
 <ceu88b$lo5$1@sparta.btinternet.com>
 <1jgik0ntrex36$.1pyha1husddpe.dlg@40tude.net>
 <41134e18$1_1@baen1673807.greenlnk.net>
 <94tir0ejn3n4$.a7o1lv87loha$.dlg@40tude.net>
 <cf28kp$rjp$1@sparta.btinternet.com>
 <13x45njobjvn3.yhisk87dws3.dlg@40tude.net>
 <cf4ojq$p4$1@hercules.btinternet.com>
 <1j730n9o2lgav$.rvhdl0zjqvnw$.dlg@40tude.net> <opscg71mkpp4pfvb@bram-2>
 <nospam-91C41E.04421010082004@news-server-fe-01.columbus.rr.com>
Mime-Version: 1.0
Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: news.uni-berlin.de YWaPl9d9xJfVaGDna1GQBwgPvDt4nEGZxp78h0pjE3a2O/2oQ=
User-Agent: Opera M2/7.51 (Win32, build 3798)
Xref: g2news1.google.com comp.lang.ada:2654
Date: 2004-08-10T19:51:07+01:00
List-Id: <comp.lang.ada>

On Tue, 10 Aug 2004 08:36:44 GMT, John B. Matthews <nospam@nospam.com>  
wrote:

> 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.

Fascinating. (I did say I wasn't sure!)

> 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 <table> values
> (..., TO_DATE(:DT_String,'YYYY-MM-DD hh:mi:ss'), ...);
>
> I understand this is non-portable.

Couldn't one simply use:

    insert into <table> values
       (..., Current_Timestamp, ...)

?

-- 
Nick Roberts