Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id C4F2E9FA24F for ; Wed, 5 Sep 2007 00:56:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 67835-05 for ; Wed, 5 Sep 2007 00:56:50 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.178]) by postgresql.org (Postfix) with ESMTP id B23049FA251 for ; Wed, 5 Sep 2007 00:56:50 -0300 (ADT) Received: by wa-out-1112.google.com with SMTP id m38so2710464waf for ; Tue, 04 Sep 2007 20:56:48 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:sender:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth; b=p+s5OpmCRQshIp4R+kS7mO7w5wGBkveGFByp556nicpjmEd70FJkYtMdMZTbFNe27Y2M0fuhsA24L0T+GTvrUckN90ux17i2cQ+y/Mx5N5NJSBtdwphSWTHkZHLPSCvg+tYaDC1BorSRR9OeopDxym3IpUj1A5hxkcvW3lNWz40= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:sender:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth; b=WAhsRjhUKFwrg1WwgEQvQPcj1iRPFi92JQHU/9FTM3//79n6bGltZ4MFQXWlu3wHTpEcRkPO6Hh744IjiCx1tWoJjg5YC6UsJxbSMwLNaTQOaoJtz/HTWpKv76uc6HnxgqG2eFzEZIJMgGxqY3fiW21IIkUMGbrCxT7eF01atfQ= Received: by 10.115.58.1 with SMTP id l1mr1134123wak.1188964608519; Tue, 04 Sep 2007 20:56:48 -0700 (PDT) Received: by 10.114.81.10 with HTTP; Tue, 4 Sep 2007 20:56:48 -0700 (PDT) Message-ID: Date: Wed, 5 Sep 2007 13:56:48 +1000 From: novice To: pgsql-general@postgresql.org, pgsql-sql@postgresql.org Subject: Re: work hour calculations In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Google-Sender-Auth: 1629e37bb988be1b X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/129 X-Sequence-Number: 120053 correction: > The result I'm expecting for the above to be > > notification_time | finished_time | actual > ------------------------+------------------------+----------------- 2007-07-06 15:50:00+10 | 2007-07-09 07:10:00+10 | 01:20:00 > 2007-07-07 12:30:00+10 | 2007-07-09 07:20:00+10 | 00:20:00 >