Received: from danbo.digsys.bg (root@danbo.digsys.bg [192.92.129.10]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA23140 for ; Wed, 15 Dec 1999 11:21:19 -0500 (EST) (envelope-from vlady@school.digsys.bg) Received: from school.digsys.bg (vlady@school.digsys.bg [193.68.6.1]) by danbo.digsys.bg (8.9.0/8.9.0) with ESMTP id SAA13425; Wed, 15 Dec 1999 18:21:13 +0200 (EET) Received: from localhost (vlady@localhost) by school.digsys.bg (8.8.5/8.8.5) with ESMTP id SAA02257; Wed, 15 Dec 1999 18:21:12 +0200 (EET) Date: Wed, 15 Dec 1999 18:21:11 +0200 (EET) From: Vladimir Terziev To: The Hermit Hacker cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] adding time to a datetime field ... how? In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Try select start_time, abstime_datetime(start_time::abstime + acctsessiontime) from log; Regards! Vladimir