| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2003-09-30 08:42:39 | Re: Time problem again? |
| Previous Message | Richard Huxton | 2003-09-30 07:40:00 | Re: Time problem again? |