Re: [SQL] sum ( time) problem

2004-06-13 Thread Willem de Jong
I'm afraid it is the only solution... Thanks for reply [EMAIL PROTECTED] (Bruno Wolff III) wrote in news:20040601140334.GA24188 @wolff.to: > On Thu, May 27, 2004 at 11:14:58 +0000, > Willem de Jong <[EMAIL PROTECTED]> wrote: >> >> >> >> If i do a sum(t

Re: [SQL] sum ( time) problem

2004-05-31 Thread Willem de Jong
"Loeke" <[EMAIL PROTECTED]> wrote in Dan heb je nog de 24-uurs notatie, en krijg je niet een result boven de 24-uurs notatie. news:[EMAIL PROTECTED]: > kijk eens bij functions and operators van de > sql help bij pgadmin > > "Willem de Jong" <[EMAIL P

[SQL] Seconds To Time

2004-05-11 Thread Willem de Jong
Hi all, I'm a newby to PGSQL, I allways use MySQL, but now we use PGSQL, so i had to convert all the MySQL-Query's to PGSQL. In MySQL we have the function Sec_to_time(seconds). This will result a time-value like '40:30:00'. With this Query SELECT TIMESTAMP WITH TIME ZONE 'epoch' + sum(elapse