Groups > comp.databases.postgresql > #700

Re: work with intervals

From	Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Newsgroups	comp.databases.postgresql
Subject	Re: work with intervals
Date	2016-01-19 10:20 +0100
Organization	A noiseless patient Spider
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>

Show all headers | 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