## Re: Time problem again?

From: Bjørn T Johansen Richard Huxton Postgres General Re: Time problem again? 2003-09-29 11:47:36 1064836056.12012.38.camel@dt-btj.dagbladet.no (view raw or flat) 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
```Well, I don't.. But normal timespan is about 6-7 hours +- (so one can
assume max timespan = 12 hours really...)

BTJ

On Mon, 2003-09-29 at 13:40, Richard Huxton wrote:

> On Monday 29 September 2003 12:26, Bjørn T Johansen wrote:
> > The problem is that I don't have such a "period". I can have a select
> > containing these data:
> >
> > 2350
> > 0110
> > 0330
> >
> > which then should be sorted like that.
> >
> > And I can also have the following:
> >
> > 1030
> > 1145
> > 1240
> >
> > (also sorted as shown...)
> >
> > the only thing I know for sure, is that the interval between the first
> > record and the last, is always less than 24 hours...
>
> And how do you know that the first example shouldn't have been
>   0110
>   0330
>   2350
```

### pgsql-general by date

 Next: From: Bjørn T Johansen Date: 2003-09-29 11:49:16 Subject: Re: Time problem again? Previous: From: Nigel J. Andrews Date: 2003-09-29 11:47:11 Subject: Re: ADD FOREIGN KEY (was Re: [GENERAL] 7.4Beta)