| 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: | Whole Thread | Raw Message | 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. |