Received: from golem.fourpalms.org (www.fourpalms.org [64.3.68.148])
	by postgresql.org (8.11.3/8.11.4) with ESMTP id f8P5f2h67973
	for <pgsql-docs@postgresql.org>; Tue, 25 Sep 2001 01:41:03 -0400 (EDT)
	(envelope-from lockhart@fourpalms.org)
Received: from fourpalms.org (localhost.localdomain [127.0.0.1])
	by golem.fourpalms.org (Postfix) with ESMTP
	id D89A5FEB6; Tue, 25 Sep 2001 05:41:00 +0000 (UTC)
Message-ID: <3BB018EC.CA3C00D4@fourpalms.org>
Date: Tue, 25 Sep 2001 05:41:00 +0000
From: Thomas Lockhart <lockhart@fourpalms.org>
Reply-To: lockhart@fourpalms.org
Organization: Yes
X-Mailer: Mozilla 4.75 [en] (X11; U; Linux 2.2.17-21mdksmp i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Cc: pgsql-docs@postgresql.org
Subject: Re: Error in date_part epoch docs.
References: <ECEHIKNFIMMECLEBJFIGKEBHCCAA.chriskl@familyhealth.com.au>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200109/66
X-Sequence-Number: 1000

> >From functions-datetime.html...
> epoch
> For date and timestamp values, the number of seconds since 1970-01-01
> 00:00:00 (Result may be negative.); for interval values, the total number of
> seconds in the interval
> This is incorrect, it's from 1970-01-01 08:00:00

Actually, it is from 1970-01-01 00:00:00 GMT. I'll clarify the docs.
Thanks for the note.

                 - Thomas