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:00:25
Message-ID: 1064908825.20427.13.camel@dt-btj.dagbladet.no (view raw or flat)
Thread:
Lists: 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.


In response to

Responses

pgsql-general by date

Next:From: Richard HuxtonDate: 2003-09-30 08:42:39
Subject: Re: Time problem again?
Previous:From: Richard HuxtonDate: 2003-09-30 07:40:00
Subject: Re: Time problem again?

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