Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 70130 invoked from network); 23 Aug 2005 15:33:17 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 23 Aug 2005 15:33:17 -0000 Received: (qmail 43102 invoked by uid 500); 23 Aug 2005 15:33:16 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 43078 invoked by uid 500); 23 Aug 2005 15:33:15 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 43065 invoked by uid 99); 23 Aug 2005 15:33:15 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 23 Aug 2005 08:33:15 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of jta@bristowhill.com designates 66.75.162.135 as permitted sender) Received: from [66.75.162.135] (HELO ms-smtp-03-eri0.socal.rr.com) (66.75.162.135) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 23 Aug 2005 08:33:32 -0700 Received: from [192.168.15.53] (cpe-204-210-23-212.san.res.rr.com [204.210.23.212]) by ms-smtp-03-eri0.socal.rr.com (8.12.10/8.12.7) with ESMTP id j7NFXAgQ023561 for ; Tue, 23 Aug 2005 08:33:10 -0700 (PDT) Message-ID: <430B41B5.1070108@bristowhill.com> Date: Tue, 23 Aug 2005 08:33:09 -0700 From: "Jean T. Anderson" User-Agent: Mozilla Thunderbird 1.0.2-1.3.2 (X11/20050324) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Derby Discussion Subject: Re: How to compute the duration of two timestamps References: <430B07A3.7010109@sun.com> <430B0C5F.5040308@solsoft.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Symantec AntiVirus Scan Engine X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Also, info about timestampdiff and timestampadd is now in the 10.1 docs: http://db.apache.org/derby/docs/10.1/ref/rrefjdbc88908.html regards, -jean Kostas Karadamoglou wrote: > Thanks! > > I found it > > Thomas Lecavelier wrote: > >> The link is correct under my thunderbird 1.0.2 >> >> http://mail-archives.apache.org/mod_mbox/db-derby-user/200508.mbox/%3c42F65517.9000606@Sourcery.Org%3e >> >> >> If this don't work, search for the mail of Satheesh Bandaram: >> Subject: Re: How to get a difference between two dates? >> Date: Sun, 07 Aug 2005 18:38:15 GMT >> >> Kostas Karadamoglou a �crit : >> >>> Hi Oyvind, >>> >>> The link is broken can you send me the valid one. >>> >>> Prior of my first post I searched my gmane mailing list using the >>> "duration" keyword but I didn't find anything >>> >> >> >