X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 55217D1C4E7 for ; Thu, 31 Jul 2003 16:05:38 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 61774-02 for ; Thu, 31 Jul 2003 13:04:32 -0300 (ADT) Received: from localhost.localdomain (pcp02833531pcs.levtwn01.pa.comcast.net [68.80.216.199]) by svr1.postgresql.org (Postfix) with ESMTP id 2BF47D1C4D7 for ; Thu, 31 Jul 2003 13:05:36 -0300 (ADT) Received: from localhost.localdomain (hvar [127.0.0.1]) by localhost.localdomain (8.12.8/8.12.5) with ESMTP id h6VG5bWd006254 for ; Thu, 31 Jul 2003 12:05:37 -0400 Received: (from mail@localhost) by localhost.localdomain (8.12.8/8.12.8/Submit) id h6VG5boE006252 for pgsql-sql@postgresql.org; Thu, 31 Jul 2003 12:05:37 -0400 X-Authentication-Warning: localhost.localdomain: mail set sender to pgsql-sql-account@basebeans.net using -f To: pgsql-sql@postgresql.org X-Injected-Via-Gmane: http://gmane.org/ Received: from localhost.localdomain (hvar [127.0.0.1]) by localhost.localdomain (8.12.8/8.12.5) with ESMTP id h6VG5aWd006247 for ; Thu, 31 Jul 2003 12:05:36 -0400 Received: (from news@localhost) by localhost.localdomain (8.12.8/8.12.8/Submit) id h6VG5aF9006245 for pgSQL@basebeans.net; Thu, 31 Jul 2003 12:05:36 -0400 Path: not-for-mail From: teknokrat Subject: converting interval to timestamp Date: Thu, 31 Jul 2003 17:05:31 +0100 Organization: baseBeans Engineering Lines: 8 Message-ID: Reply-To: teknokrat@yahoo.com NNTP-Posting-Host: borsh01.free-online.co.uk Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Trace: localhost.localdomain 1059667536 6222 212.56.93.181 (31 Jul 2003 16:05:36 GMT) X-Complaints-To: news@news.basebeans.net NNTP-Posting-Date: Thu, 31 Jul 2003 16:05:36 +0000 (UTC) User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.0+) Gecko/20020518 X-Accept-Language: en-us, en, ko X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/491 X-Sequence-Number: 14605 The difference of two dates/timestamps always gives an interval. is there a way to convert this interval into number such as number of milliseconds or number of days? Also does anyone know what field type an interval would map to in jdbc? thanks