i***@thepathcentral.com
2016-06-03 23:44:04 UTC
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')
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-***@postgresql.org)
To make changes to your subscription:
http://
Sent via pgsql-docs mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://