| From: | Willem de Jong <Willumpie(at)xs4all(dot)nl> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: sum ( time) problem |
| Date: | 2004-05-27 11:14:58 |
| Message-ID: | Xns94F687197CDCDJongdatdnaservicesdo@200.46.204.72 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
"Loeke" <LoekeDoeLoekeDoe(at)dontlikespam(dot)hotmail(dot)com> wrote in
Dan heb je nog de 24-uurs notatie, en krijg je niet een result boven de
24-uurs notatie.
news:1084406549(dot)228484(at)seven(dot)kulnet(dot)kuleuven(dot)ac(dot)be:
> kijk eens bij functions and operators van de
> sql help bij pgadmin
>
> "Willem de Jong" <Willumpie(at)xs4all(dot)nl> wrote in message
> news:Xns94E7AEA1D11BBJongdatdnaservicesdo(at)200(dot)46(dot)204(dot)72(dot)(dot)(dot)
>> Hello,
>>
>> If i do a sum(time) the result is like this '1 day 18:00:00'. But i'd
>> like to get a result like this '42:00:00'.
>>
>> How can i realise is by a query?
>>
>> thanks in advance,
>>
>> Willem de Jong.
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Luc Lachance | 2004-05-27 13:08:35 | Re: Multitable uniqueness ? |
| Previous Message | Andreas | 2004-05-27 07:22:53 | Re: Multitable uniqueness ? |