Skip site navigation (1) Skip section navigation (2)

Re: Time problem again?

From: Bjørn T Johansen <btj(at)havleik(dot)no>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Time problem again?
Date: 2003-09-30 08:50:21
Message-ID: 1064911821.20427.16.camel@dt-btj.dagbladet.no (view raw or flat)
Thread:
Lists: pgsql-general
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


In response to

Responses

pgsql-general by date

Next:From: Karsten HilbertDate: 2003-09-30 09:13:04
Subject: Re: Time problem again?
Previous:From: Angel TodorovDate: 2003-09-30 08:43:19
Subject: pg_hba.conf

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group