Posted by brazil.mg.marcus.vinicius.lima on 09/19/07 02:28

On 18 set, 20:54, "Roy Harvey (MVP)" <roy_har...@snet.net> 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"
>
>
>
> <marcvl...@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!- 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!

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