Jesus Cardenas wrote:
> Hi Group!
>
> I've two fields of type datetime and I want know how to calculate difference
> in fraccion of hours,
>
> if I execute this
>
> select datediff(mi, convert(datetime,'2004-09-14 11:30:15.000'),
> convert(datetime,'2004-09-14 12:00:57.000') )
>
> the result is 30, but if I execute this
>
> select datediff(mi, convert(datetime,'2004-09-14 11:30:15.000'),
> convert(datetime,'2004-09-14 12:00:57.000') ) /60
>
> the result is 0 and should be 0.5 hrs.
>
> What's wrong with my code?
>
> How can I get the fraction of hours ?
>
>

"nib" <nib@nibsworld.com> wrote in message
news:eXMoWICrEHA.2948@TK2MSFTNGP11.phx.gbl...
>
>
> Jesus Cardenas wrote:
> > Hi Group!
> >
> > I've two fields of type datetime and I want know how to calculate
difference
> > in fraccion of hours,
> >
> > if I execute this
> >
> > select datediff(mi, convert(datetime,'2004-09-14 11:30:15.000'),
> > convert(datetime,'2004-09-14 12:00:57.000') )
> >
> > the result is 30, but if I execute this
> >
> > select datediff(mi, convert(datetime,'2004-09-14 11:30:15.000'),
> > convert(datetime,'2004-09-14 12:00:57.000') ) /60
> >
> > the result is 0 and should be 0.5 hrs.
> >
> > What's wrong with my code?
> >
> > How can I get the fraction of hours ?
> >
> >
>
> Change 60 to 60.0.
>
> Zach