## Re: Time problem again?

From: Bjørn T Johansen Richard Huxton Postgres General Re: Time problem again? 2003-09-30 08:00:25 1064908825.20427.13.camel@dt-btj.dagbladet.no (view raw or whole thread) 2003-09-29 09:11:55 from Bjørn T Johansen  2003-09-29 11:21:33 from Richard Huxton   2003-09-29 11:26:41 from Bjørn T Johansen    2003-09-29 11:40:25 from Richard Huxton     2003-09-29 11:47:36 from Bjørn T Johansen      2003-09-29 13:22:23 from Richard Huxton       2003-09-29 19:19:42 from Bjørn T Johansen        2003-09-29 19:38:25 from Tom Lane         2003-09-29 20:33:42 from Bjørn T Johansen        2003-09-29 19:53:05 from Richard Huxton         2003-09-29 20:31:31 from Bjørn T Johansen          2003-09-30 07:40:00 from Richard Huxton           2003-09-30 08:00:25 from Bjørn T Johansen            2003-09-30 08:42:39 from Richard Huxton             2003-09-30 08:50:21 from Bjørn T Johansen              2003-09-30 09:24:53 from Richard Huxton               2003-09-30 09:54:37 from Bjørn T Johansen            2003-09-30 09:13:04 from Karsten Hilbert  2003-09-29 11:44:48 from "Daniel Schuchardt"   2003-09-29 11:49:16 from Bjørn T Johansen 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
>
> yet.

```

### pgsql-general by date

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