Groups > comp.databases.postgresql > #700

Re: work with intervals

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> (permalink)
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

Show key headers only | View raw

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

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

work with intervals Magnus Warker <magnux@mailinator.com> - 2016-01-06 13:39 +0100
  Re: work with intervals Harry Tuttle <SOZRBLNTLEEE@spammotel.com> - 2016-01-08 10:46 +0100
    Re: work with intervals Magnus Warker <magnux@mailinator.com> - 2016-01-08 19:57 +0100
    Re: work with intervals Magnus Warker <magnux@mailinator.com> - 2016-01-09 06:56 +0100
      Re: work with intervals Harry Tuttle <SOZRBLNTLEEE@spammotel.com> - 2016-01-09 10:07 +0100
        Re: work with intervals Magnus Warker <magnux@mailinator.com> - 2016-01-19 06:43 +0100
          Re: work with intervals Dimitri Fontaine <dimitri@2ndQuadrant.fr> - 2016-01-19 10:20 +0100
            Re: work with intervals Magnus Warker <magnux@mailinator.com> - 2016-01-31 06:04 +0100

csiph-web