Message-ID: <3EC04E3D.4000305@xtenit.com>
Date: Mon, 12 May 2003 21:45:33 -0400
From: Joseph Shraibman <joseph@xtenit.com>
Organization: Xtenit, Inc. http://www.xtenit.com
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4a) Gecko/20030401
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
CC: nolan@celery.tssi.com, PostgreSQL General <pgsql-general@postgresql.org>
Subject: Re: [GENERAL] fomatting an interval
References: <20030513000724.1561.qmail@celery.tssi.com>
	<3EC03AAB.4000705@selectacast.net> <25315.1052788160@sss.pgh.pa.us>
In-Reply-To: <25315.1052788160@sss.pgh.pa.us>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Tom Lane wrote:
>>>>How can I format an interval?
> 
> 
> Well, there are several possibilities such as to_char() and EXTRACT()
> ...
> 
Right, except I don't know what format to use for to_char()

> 
>>I want something like the default format but without the milliseconds.
> 
> 
> ... but for this particular problem, why not just round the given
> interval to an integral number of seconds, by casting it to interval(0)?
> 

playpen=# select version();
                                version
---------------------------------------------------------------------
  PostgreSQL 7.3.2 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66
(1 row)

playpen=# begin;
BEGIN
playpen=# create table timetable (start timestamp, finish timestamp);
CREATE TABLE
playpen=# insert into timetable values('2003-05-12 21:37:44.933',  '2003-05-12 21:39:14.752');
INSERT 1648889 1
playpen=# select start, finish, (finish-start),(finish-start)::interval(0) from timetable;
           start          |         finish          |   ?column?   |   interval
-------------------------+-------------------------+--------------+--------------
  2003-05-12 21:37:44.933 | 2003-05-12 21:39:14.752 | 00:01:29.819 | 00:01:29.819
(1 row)