How to work with time in format "hhh:mm:ss" (more than 24 hours)

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!

Re: How to work with time in format "hhh:mm:ss" (more than 24 hours)

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"
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!

Re: How to work with time in format "hhh:mm:ss" (more than 24 hours)

On 18 set, 20:54, "Roy Harvey (MVP)" wrote:
> 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"
>
>
>
> 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!- Ocultar texto entre aspas -
>
> - Mostrar texto entre aspas -

Re: How to work with time in format "hhh:mm:ss" (more than 24 hours)

On 18 set, 20:54, "Roy Harvey (MVP)" wrote:
> 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"
>
>
>
> 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!- Ocultar texto entre aspas -
>
> - Mostrar texto entre aspas -

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!

Re: How to work with time in format "hhh:mm:ss" (more than 24 hours)

On Tue, 18 Sep 2007 19:28:20 -0700, "brazil.mg.marcus.vinicius.lima"
wrote:

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

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

Roy Harvey
Beacon Falls, CT