You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by Kostas Karadamoglou <ka...@yahoo.gr> on 2005/08/23 13:18:26 UTC

How to compute the duration of two timestamps

Hi,

How can I compute the duration of two timestamps?
Is there any built-in function that helps?

Are any alternative options?

Thank you in advance, Kostas

Re: How to compute the duration of two timestamps

Posted by "Jean T. Anderson" <jt...@bristowhill.com>.

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

Re: How to compute the duration of two timestamps

Posted by Kostas Karadamoglou <ka...@yahoo.gr>.

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

Re: How to compute the duration of two timestamps

Posted by Thomas Lecavelier <th...@solsoft.com>.

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
>

Re: How to compute the duration of two timestamps

Posted by Kostas Karadamoglou <ka...@yahoo.gr>.

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

Oyvind.Bakksjo@Sun.COM wrote:
> Kostas Karadamoglou wrote:
> 
>> Hi,
>>
>> How can I compute the duration of two timestamps?
>> Is there any built-in function that helps?
>>
>> Are any alternative options?
> 
> 
> This question was asked on this list not so long ago. You can find the 
> answer in the mailing list archives:
> 
> http://mail-archives.apache.org/mod_mbox/db-derby-user/200508.mbox/%3c42F65517.9000606@Sourcery.Org%3e 
> 
>

Re: How to compute the duration of two timestamps

Posted by Oy...@Sun.COM.

Kostas Karadamoglou wrote:
> Hi,
> 
> How can I compute the duration of two timestamps?
> Is there any built-in function that helps?
> 
> Are any alternative options?

This question was asked on this list not so long ago. You can find the 
answer in the mailing list archives:

http://mail-archives.apache.org/mod_mbox/db-derby-user/200508.mbox/%3c42F65517.9000606@Sourcery.Org%3e

-- 
Øyvind Bakksjø
Sun Microsystems, Database Technology Group
Haakon VII gt. 7b, N-7485 Trondheim, Norway
Tel: x43419 / +47 73842119, Fax: +47 73842101