| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Bjørn T Johansen <btj(at)havleik(dot)no> |
| Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Time problem again? |
| Date: | 2003-09-29 19:53:05 |
| Message-ID: | 200309292053.05604.dev@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 2003-09-29 20:09:05 | Re: Triggers and COPY |
| Previous Message | Molly Gibson | 2003-09-29 19:42:20 | Re: mod_auth_pgsql & encryption |