Path: csiph.com!eternal-september.org!feeder.eternal-september.org!mx02.eternal-september.org!.POSTED!not-for-mail
From: Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Newsgroups: comp.databases.postgresql
Subject: Re: work with intervals
Date: Tue, 19 Jan 2016 10:20:49 +0100
Organization: A noiseless patient Spider
Lines: 20
Message-ID: <m237tu3oy6.fsf@2ndQuadrant.fr>
References: <n6j1un$lbj$1@news.m-online.net> <df9esaFih4aU1@mid.individual.net> <n6q7du$lfn$1@news.m-online.net> <dfc0vhF7oj6U1@mid.individual.net> <n7kidj$sm0$1@news.m-online.net>
Mime-Version: 1.0
Content-Type: text/plain
Injection-Info: mx02.eternal-september.org; posting-host="1d4e32905d8c3b3f9165311ae7981c1f"; logging-data="306"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX188AeRXGJaQ4HHtwh1fgoZt"
User-Agent: Gnus/5.13001 (Ma Gnus v0.10) Emacs/24.5 (darwin)
Cancel-Lock: sha1:CA9aomT6REwEFa4eaM9bSGQUQUI= sha1:1GRfo9T8LCSsarqjMtrIEm25iI4=
Xref: csiph.com comp.databases.postgresql:700

Magnus Warker <magnux@mailinator.com> writes:
> mydb=# select duration from vds_run;
>  duration
> ----------
>  00:55:39

> What durations do we see here?
> hour:minute:second?

# set intervalstyle to 'postgres_verbose';
SET
# select interval '00:55:39';
     interval      
-------------------
 @ 55 mins 39 secs
(1 row)

-- 
Dimitri Fontaine
PostgreSQL DBA, Architecte