Re: Indicated Epoch 0 is incorrect
| От | Steve Crawford |
|---|---|
| Тема | Re: Indicated Epoch 0 is incorrect |
| Дата | |
| Msg-id | CAEfWYyzs6sVF1ftryEwNfwpx7pzsjYv=7=dPXDUkQxx22uXDqA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Indicated Epoch 0 is incorrect (ian@thepathcentral.com) |
| Список | pgsql-docs |
The docs are correct. When you convert a string to a timestamp with time zone it will interpret the string in *your* time zone which is apparently offset from UTC.
Try:
select extract(epoch from timestamp with time zone '1970-01-01 00:00:00-00');
or
select extract(epoch from timestamp with time zone '1970-01-01 00:00:00 UTC');
Note the explicit definition of timezone offset of zero or time zone of UTC.
Cheers,
Steve
On Fri, Jun 3, 2016 at 4:44 PM, <ian@thepathcentral.com> wrote:
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.1/static/functions-datetime.html
Description:
Per /docs/current/static/functions-datetime.html (and earlier), epoch is
defined as:
"For date and timestamp values, the number of seconds since 1970-01-01
00:00:00 UTC".
The correct value to obtain 0 is as follows:
SELECT EXTRACT(EPOCH FROM TIMESTAMP WITH TIME ZONE '1970-01-01 8:00:00.0')
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
В списке pgsql-docs по дате отправления: