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-29 11:47:36
Message-ID: 1064836056.12012.38.camel@dt-btj.dagbladet.no (view raw or flat)
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

pgsql-general by date

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

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