db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dmitri Pissarenko" <dmitri.pissare...@gmail.com>
Subject Re: Sum of time
Date Wed, 18 Jul 2007 21:57:06 GMT
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.

Of course, I could do the conversion (seconds/milliseconds to
HH:MM:SS) in Crystal Reports, but it's easier for me to do it this
way.

Best regards

Dmitri Pissarenko
-- 
http://www.xing.com/profile/Dmitri_Pissarenko
http://dapissarenko.blogspot.com/

Mime
View raw message