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 по дате отправления: