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-29 11:47:36
Message-ID: 1064836056.12012.38.camel@dt-btj.dagbladet.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

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