db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Thornton <mthorn...@optrak.co.uk>
Subject Re: Sum of time
Date Thu, 19 Jul 2007 07:37:52 GMT
Dmitri Pissarenko wrote:
> On 7/18/07, Raymond Kroeker <raymond@thinkparity.com> wrote:
>> Can I ask why you wouldn't store the duration as a simple bigint
>> representing the number of seconds/milliseconds?
> This field must have time type because a report is based on it. The
> report is done with Crystal Reports and I need the duration to be
> printed as hours, minutes and seconds (01:30:40), not as
> seconds/milliseconds.
Your approach may fail if the duration reaches or exceeds 24 hours. 
Attempting to set a time field to a value greater than 24 hours often 
results in an exception.

Mark Thornton

View raw message