| From: | David Pirotte <david(at)altosw(dot)be> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | interval output format ? |
| Date: | 2001-03-18 16:41:28 |
| Message-ID: | 3AB4E537.A22FFDB4@altosw.be |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
Given the following table:
pilotage=# \d vols
Table "vols"
Attribute | Type | Modifier
-------------+----------+----------
jour | date |
modele | char(20) |
matricule | char(20) |
pilote1 | char(20) |
pilote2 | char(20) |
origine | char(20) |
destination | char(20) |
double | interval |
comandant | interval |
description | text |
code | char(10) |
and the following query:
pilotage=# select sum(comandant) from vols;
sum
--------------------------
@ 1 day 19 hours 18 mins
(1 row)
how can I ask postgres to return
43:18
instead of
@ 1 day 19 hours 18 mins
Thanks,
David
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-03-18 17:21:25 | Re: interval output format ? |
| Previous Message | Peter Morgan | 2001-03-18 15:56:34 | Migrating from MS SQL 7 |