Received: from finch-post-11.mail.demon.net (finch-post-11.mail.demon.net [194.217.242.39]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5LI3Ia96978 for ; Thu, 21 Jun 2001 14:03:18 -0400 (EDT) (envelope-from dev@archonet.com) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by finch-post-11.mail.demon.net with esmtp (Exim 2.12 #1) id 15D8nU-000JRv-0B; Thu, 21 Jun 2001 18:03:16 +0000 Received: from client (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with SMTP id AB37813650; Thu, 21 Jun 2001 18:47:11 +0100 (BST) Message-ID: <004901c0fa7a$329d5620$1001a8c0@archonet.com> From: "Richard Huxton" To: "Tom Lane" Cc: "pgsql" , "Najm Hashmi" References: <3B2F73BA.8EBA2FD1@flipr.com> <009c01c0fa32$21fb4cc0$1001a8c0@archonet.com> <13009.993132307@sss.pgh.pa.us> Subject: Re: Extracting date from epoche Date: Thu, 21 Jun 2001 18:47:09 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200106/337 X-Sequence-Number: 3624 From: "Tom Lane" > "Richard Huxton" writes: > > Tom - I thought 'epoch'::timestamp should work too - good reason, or just > > One Of Those Things (tm)? > > It works --- it's a symbolic value, though. > > regression=# select 'epoch'::timestamp; > ?column? > ---------- > epoch > (1 row) > > regression=# select 'epoch'::timestamp + ('1 day'::interval); > ?column? > ------------------------ > 1970-01-01 19:00:00-05 > (1 row) Ah - problem is in my wetware then. That's ok. - Richard Huxton