X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id A73AAD1B53C for ; Thu, 16 Oct 2003 03:37:21 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 10620-03 for ; Thu, 16 Oct 2003 00:36:50 -0300 (ADT) Received: from chekov.mclachlan.com.au (unknown [203.185.220.172]) by svr1.postgresql.org (Postfix) with SMTP id 949E4D1B4E8 for ; Thu, 16 Oct 2003 00:36:48 -0300 (ADT) Received: (qmail 24248 invoked from network); 16 Oct 2003 03:44:53 -0000 Received: from picard.mclachlan.com.au (192.168.1.254) by mail.mclachlan.com.au with SMTP; 16 Oct 2003 03:44:53 -0000 Received: (qmail 7940 invoked by uid 547); 16 Oct 2003 03:39:40 -0000 Date: Thu, 16 Oct 2003 13:39:40 +1000 From: Wilson Fletcher To: pgsql-sql@postgresql.org Subject: Re: convert integer seconds to timestamp Message-ID: <20031016133940.A7903@mclachlan.com.au> References: <20031016133111.A7731@mclachlan.com.au> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5.1i In-Reply-To: <20031016133111.A7731@mclachlan.com.au>; from research@mclachlan.com.au on Thu, Oct 16, 2003 at 01:31:11PM +1000 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/185 X-Sequence-Number: 15585 Sorry, I found the answer to this on the list. ie. select date::abstime from .... BUT, how do I get it in local time ? ie. - 10 or 11 hours depending on daylight savings. thanks. On Thu, Oct 16, 2003 at 01:31:11PM +1000, Wilson Fletcher wrote: > How can I convert epoch seconds (as an interger) to a timestamp ? > > I've already seen the post below BUT it doesn't work. I suspect it is out of date: > http://archives.postgresql.org/pgsql-sql/2000-09/msg00190.php > > thanks. > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster