Understanding PGInterval - Mailing list pgsql-jdbc

From r.trommer@open-factory.org
Subject Understanding PGInterval
Date
Msg-id e25af22b-a772-4eaa-963e-0ca2897bb3bd@h28g2000yqd.googlegroups.com
Whole thread Raw
Responses Re: Understanding PGInterval  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
Hello List,

i try to understand how i can use the PGInterval Object. I have to
solve a little issue in Java. I have created a SQL-statement which
give me a resultset like this:

id | duration
1  | 01:49:00
2  | 00:30:00

The datetypes id = int and duration = PGInterval. I would like to sum
the both duration values in Java. I can´t use a SQL sum because i need
the results later to report some details.

I use postgresql-8.1-404.jdbc2.jar

Thank you in advance

Ronny

pgsql-jdbc by date:

Previous
From: Guy Rouillier
Date:
Subject: Re: Log4j Appender
Next
From: Kris Jurka
Date:
Subject: Re: Understanding PGInterval