X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (developer.postgresql.org [64.117.224.193])
	by developer.postgresql.org (Postfix) with ESMTP id 87402925B15
	for <pgsql-sql@postgresql.org>; Fri, 30 May 2003 14:04:07 -0400 (EDT)
Received: from developer.postgresql.org ([64.117.224.193])
	by localhost (developer.postgresql.org [64.117.224.193:10024])
	(amavisd-new) with ESMTP id 65409-02 for <pgsql-sql@postgresql.org>;
	Fri, 30 May 2003 14:04:07 -0400 (EDT)
Received: from hotmail.com (law12-f35.law12.hotmail.com [64.4.19.35])
	by developer.postgresql.org (Postfix) with ESMTP id A4D16925A9D
	for <pgsql-sql@postgresql.org>; Fri, 30 May 2003 14:04:06 -0400 (EDT)
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
	Fri, 30 May 2003 11:04:05 -0700
Received: from 207.34.65.240 by lw12fd.law12.hotmail.msn.com with HTTP;
	Fri, 30 May 2003 18:04:05 GMT
X-Originating-IP: [207.34.65.240]
X-Originating-Email: [daniel_katka@hotmail.com]
From: "Katka a Daniel Dunajsky" <daniel_katka@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: Calculating with the time
Date: Fri, 30 May 2003 12:04:05 -0600
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
Message-ID: <Law12-F35awhftgLeCR0002781b@hotmail.com>
X-OriginalArrivalTime: 30 May 2003 18:04:05.0892 (UTC)
	FILETIME=[DC177440:01C326D5]
X-Virus-Scanned: by amavisd-new
X-Archive-Number: 200305/577
X-Sequence-Number: 13742

Hello All,

I am looking for an advice how to do calculation with the time. I do have a 
column with datatype 'timestamp with time zone'. The value is '2003-03-22 
07:53:56-07' for instance. I would like to select it from the table with 
result of '07:59:59' – '07:53:56', so the query should return '00:06:03'.

Thank you for your time.

DanielD

_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail