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!

There is no such data type in SQL Server. In SQL Server 2008 we have
been promised a TIME datatype that ranges from 00:00:00 to 23:59:59
(plus milliseconds), but it does not reach 24:00:00, much less go
beyond it.

I would consider that as a display requirement, and store in some
other form such as seconds, converting as needed for display.

Roy Harvey
Beacon Falls, CT

On Tue, 18 Sep 2007 16:28:44 -0700, "brazil.mg.marcus.vinicius.lima"
<marcvlima (AT) gmail (DOT) com> wrote:

On 18 set, 20:54, "Roy Harvey (MVP)" <roy_har... (AT) snet (DOT) net> wrote:

On 18 set, 20:54, "Roy Harvey (MVP)" <roy_har... (AT) snet (DOT) net> wrote:
Thanks for your comment.

When I perform a datetime subtraction (get the diference between two
dates) can i convert the results to seconds?
Thanks a lot!

On Tue, 18 Sep 2007 19:28:20 -0700, "brazil.mg.marcus.vinicius.lima"
<marcvlima (AT) gmail (DOT) com> wrote:

The DATEDIFF function's first parameter specifies if the difference is
calculated in seconds, minutes, hours, weeks, years, etc.

Roy Harvey
Beacon Falls, CT