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