On Tue, 2003-09-30 at 10:42, Richard Huxton wrote:
> So - your rule is something like:
>
> For some block of times...
> IF max(my_time) - min(my_time) > 12 hours
> THEN sort "through midnight"
> ELSE sort "naturally"
>
> Which is what Tom said (I was wondering where he got his 12 hours from).
> Have I got that right?
Yes, that sounds about right.. :)
But how do I code this in an Select statement?
BTJ