Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5LE5Fa86555 for ; Thu, 21 Jun 2001 10:05:15 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id f5LE57313012; Thu, 21 Jun 2001 10:05:07 -0400 (EDT) To: "Richard Huxton" cc: "pgsql" , "Najm Hashmi" Subject: Re: Extracting date from epoche In-reply-to: <009c01c0fa32$21fb4cc0$1001a8c0@archonet.com> References: <3B2F73BA.8EBA2FD1@flipr.com> <009c01c0fa32$21fb4cc0$1001a8c0@archonet.com> Comments: In-reply-to "Richard Huxton" message dated "Thu, 21 Jun 2001 10:11:17 +0100" Date: Thu, 21 Jun 2001 10:05:07 -0400 Message-ID: <13009.993132307@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200106/328 X-Sequence-Number: 3615 "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) Note the epoch is midnight GMT = 7pm local time here. regards, tom lane