Dmitri Pissarenko wrote:
On 7/18/07, Raymond Kroeker <[EMAIL PROTECTED]> 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
