interval output format ?
| От | David Pirotte |
|---|---|
| Тема | interval output format ? |
| Дата | |
| Msg-id | 3AB4E537.A22FFDB4@altosw.be обсуждение исходный текст |
| Ответы |
Re: interval output format ?
Re: interval output format ? |
| Список | 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
В списке pgsql-general по дате отправления: