Re: Time problem again? - Mailing list pgsql-general

From Bjørn T Johansen
Subject Re: Time problem again?
Date
Msg-id 1064908825.20427.13.camel@dt-btj.dagbladet.no
Whole thread Raw
In response to Re: Time problem again?  (Richard Huxton <dev@archonet.com>)
Responses Re: Time problem again?
Re: Time problem again?
List pgsql-general
Why can't you just take my word for it, this is the way it should be
sorted....

The reason I know this, is because the timespan, as I have mention
before, from first record to last record is always less than 12 hours.
i.e the span from 0200 to 2200 is 20 hours, i.e. 2200 comes before 0200!


BTJ

On Tue, 2003-09-30 at 09:40, Richard Huxton wrote:
> On Monday 29 September 2003 21:31, Bjørn T Johansen wrote:
> > Well, I won't get times with a span like that....
>
> OK - if you can explain what the rules are, I can tell you how to sort them.
> From the information you've given it's impossible. I can't see any way that
> you can decide that the right order is:
>   2200 2300 0200 0400
> and not
>   0200 0400 2200 2300
>
> I'm guessing there's some more information available you haven't mentioned
> yet.


pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Time problem again?
Next
From: Richard Huxton
Date:
Subject: Re: Time problem again?