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