Posted by Roy Harvey (MVP) on 09/18/07 23:54

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@gmail.com> wrote:

>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: time conversion hiccup
• Prev in forum: How to work with time in format 'hhh:mm:ss' (more than 24 hours)
• Thread view: Re: How to work with time in format 'hhh:mm:ss' (more than 24 hours)

[Reply to this message]