Re: Error in date_part epoch docs. - Mailing list pgsql-docs

From Christopher Kings-Lynne
Subject Re: Error in date_part epoch docs.
Date
Msg-id ECEHIKNFIMMECLEBJFIGCEBJCCAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: Error in date_part epoch docs.  (Thomas Lockhart <lockhart@fourpalms.org>)
List pgsql-docs
Oooh.  Now that's an interesting point!  That's going to play merry havoc
with our code.  Is there a way of GMT'ing everything?

Chris

> -----Original Message-----
> From: lockhart@fourpalms.org [mailto:lockhart@fourpalms.org]
> Sent: Tuesday, 25 September 2001 1:41 PM
> To: Christopher Kings-Lynne
> Cc: pgsql-docs@postgresql.org
> Subject: Re: [DOCS] Error in date_part epoch docs.
>
>
> > >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
>


pgsql-docs by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: Error in date_part epoch docs.
Next
From: Thomas Lockhart
Date:
Subject: Re: Error in date_part epoch docs.