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 3A646D1B52C for ; Thu, 16 Oct 2003 03:42: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 10705-06 for ; Thu, 16 Oct 2003 00:41:50 -0300 (ADT) Received: from chekov.mclachlan.com.au (unknown [203.185.220.172]) by svr1.postgresql.org (Postfix) with SMTP id F4178D1B500 for ; Thu, 16 Oct 2003 00:41:43 -0300 (ADT) Received: (qmail 24256 invoked from network); 16 Oct 2003 03:49:49 -0000 Received: from picard.mclachlan.com.au (192.168.1.254) by mail.mclachlan.com.au with SMTP; 16 Oct 2003 03:49:49 -0000 Received: (qmail 8022 invoked by uid 547); 16 Oct 2003 03:44:35 -0000 Date: Thu, 16 Oct 2003 13:44:35 +1000 From: Wilson Fletcher To: pgsql-sql@postgresql.org Subject: Re: convert integer seconds to timestamp Message-ID: <20031016134435.B7903@mclachlan.com.au> References: <20031016133111.A7731@mclachlan.com.au> <20031016133940.A7903@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: <20031016133940.A7903@mclachlan.com.au>; from research@mclachlan.com.au on Thu, Oct 16, 2003 at 01:39:40PM +1000 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/186 X-Sequence-Number: 15586 Sorry again. I don't think I will post any more. I have found the answer I needed. Thanks. Sorry for the redundant questions. On Thu, Oct 16, 2003 at 01:39:40PM +1000, Wilson Fletcher wrote: > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)