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?
In response to
pgsql-general by date
|Next:||From: Karsten Hilbert||Date: 2003-09-30 09:13:04|
|Subject: Re: Time problem again?|
|Previous:||From: Angel Todorov||Date: 2003-09-30 08:43:19|