pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Thomas Lockhart <lockhart@fourpalms.org>
To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Cc: pgsql-docs@postgresql.org
Subject: Re: Error in date_part epoch docs.
Date: Tue, 25 Sep 2001 05:41:00 +0000
Message-ID: <3BB018EC.CA3C00D4@fourpalms.org> (raw)
References: <ECEHIKNFIMMECLEBJFIGKEBHCCAA.chriskl@familyhealth.com.au>

> >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



view thread (4+ messages)  latest in thread

Message-ID: <3BB018EC.CA3C00D4@fourpalms.org>
Permalink:  ../3BB018EC.CA3C00D4@fourpalms.org/
Also on:    postgresql.org/message-id/3BB018EC.CA3C00D4@fourpalms.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: lockhart@fourpalms.org, chriskl@familyhealth.com.au
  Subject: Re: Error in date_part epoch docs.
  In-Reply-To: <3BB018EC.CA3C00D4@fourpalms.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox