PHWinfo - Afficher un message - How to work with time in format 'hhh:mm:ss' (more than 24 hours)

19/09/2007, 00h54

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!

19/09/2007, 00h54	#2
Roy Harvey (MVP) Messages: n/a Hébergeur:	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" <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!