Re: Error in date_part epoch docs.

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: <lockhart(at)fourpalms(dot)org>
Cc: <pgsql-docs(at)postgresql(dot)org>
Subject: Re: Error in date_part epoch docs.
Date: 2001-09-25 06:06:35
Message-ID: ECEHIKNFIMMECLEBJFIGCEBJCCAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)fourpalms(dot)org [mailto:lockhart(at)fourpalms(dot)org]
> Sent: Tuesday, 25 September 2001 1:41 PM
> To: Christopher Kings-Lynne
> Cc: pgsql-docs(at)postgresql(dot)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
>

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Thomas Lockhart 2001-09-25 13:17:15 Re: Error in date_part epoch docs.
Previous Message Thomas Lockhart 2001-09-25 05:41:00 Re: Error in date_part epoch docs.