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