Posted by DonLi2006 on 09/19/07 21:47

Yeah, I solved it in a similar fasion this morning, sorry for the late
update.

On Sep 19, 9:32 am, Ed Murphy <emurph...@socal.rr.com> wrote:
> DonLi2...@gmail.com wrote:
> > ahe, I spoke a bit too soon, new prob.
> > data sets:
> > start stop
> > 19:30 02:15 (next day morning)
> > 26:15 (invalid hh:mm time range)
>
> > CASE WHEN (datediff(n,start,stop) < 0) THEN 0 END
>
> Assuming that the stop time is always within 24 hours after the
> start time:
>
> case
> when datediff(n,start,stop) < 0
> then datediff(n,start,stop) + 1440 -- minutes per day
> else datediff(n,start,stop)
> end

• Next in forum: Re: How to select count records that "contain" data?
• Prev in forum: How to select count records that "contain" data?
• Thread view: Re: time conversion hiccup

[Reply to this message]