Posted by brazil.mg.marcus.vinicius.lima on 09/18/07 23:28

Hello,

I need to create a column that will store hours bigger than 24. For
example '25:00:00', '129:23:12', etc).

That column will be used too, for perform calculations between
datetime intervals: 'time'.
In MySQL there is a datatype that perfect fits that necessity.

Does anyone know what is the corresponding datatype in SQL Server?

Thanks a lot!

• Next in forum: Re: How to work with time in format 'hhh:mm:ss' (more than 24 hours)
• Prev in forum: Re: Comparing databases
• Thread view: How to work with time in format 'hhh:mm:ss' (more than 24 hours)

[Reply to this message]