Re: Time problem again? - Mailing list pgsql-general

From Bjørn T Johansen
Subject Re: Time problem again?
Date
Msg-id 1064867490.28496.33.camel@pennywise.havleik.no
Whole thread Raw
In response to Re: Time problem again?  (Richard Huxton <dev@archonet.com>)
Responses Re: Time problem again?
List pgsql-general
Well, I won't get times with a span like that....

On Mon, 2003-09-29 at 21:53, Richard Huxton wrote:
On Monday 29 September 2003 20:19, Bjørn T Johansen wrote:
> Well I know the order I want!
>
> The order should be like this during night time:
>
> 2230
> 2350
> 0100
> 0350
>
>
> and
>
> 1030
> 1145
> 1230
> 1315
>
> on day time...
> But that was my initial question, "As far as I can tell, there is no way
> to solve this without also supplying a date or am I missing something?"

And when does night-time end and day-time begin? If you have times: 0500 0600 0900 1200 1500 1900 2200 2300
is that the order or do you want 2200 2300 0500 0600 0900 1200 1500 1900

If you can tell me that, then the problem can be solved by the code I provided 
earlier

pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Triggers and COPY
Next
From: Bjørn T Johansen
Date:
Subject: Re: Time problem again?