interval output format ?

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-general by date

  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