Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1diojy-0006IC-8m for pgsql-docs@arkaria.postgresql.org; Fri, 18 Aug 2017 21:23:38 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1diojx-0000Fm-RV for pgsql-docs@arkaria.postgresql.org; Fri, 18 Aug 2017 21:23:37 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1diaQ3-0005Z3-7r for pgsql-docs@postgresql.org; Fri, 18 Aug 2017 06:06:07 +0000 Received: from wrigleys.postgresql.org ([204.145.124.246]) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1diaPz-0000X1-G6 for pgsql-docs@postgresql.org; Fri, 18 Aug 2017 06:06:06 +0000 MIME-Version: 1.0 Subject: Requesting clarifying details on extract(epoch from timestamp) To: pgsql-docs@postgresql.org From: ralph.holz@gmail.com Date: Fri, 18 Aug 2017 06:05:06 +0000 Message-ID: <20170818060506.27369.84309@wrigleys.postgresql.org> Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org VGhlIGZvbGxvd2luZyBkb2N1bWVudGF0aW9uIGNvbW1lbnQgaGFzIGJlZW4g bG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKUGFnZTogaHR0cHM6Ly93d3cucG9z dGdyZXNxbC5vcmcvZG9jcy85LjYvc3RhdGljL2Z1bmN0aW9ucy1kYXRldGlt ZS5odG1sCkRlc2NyaXB0aW9uOgoKSGkgZXZlcnlvbmUsDQoNCkkgd291bGQg bGlrZSB0byByZXF1ZXN0IGEgY2xhcmlmeWluZyBzdGF0ZW1lbnQgaW4gdGhl IGRvY3M6DQoNCmh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL2FjY291bnQv Y29tbWVudHMvbmV3LzkuNi9mdW5jdGlvbnMtZGF0ZXRpbWUuaHRtbC8NCg0K U3BlY2lmaWNhbGx5LCBmb3IgdGhlIGNhc2Ugb2YgJiMzOTtleHRyYWN0IGVw b2NoJiMzOTssIHRoZSBkb2NzIHN0YXRlOg0KDQomcXVvdDtmb3IgZGF0ZSBh bmQgdGltZXN0YW1wIHZhbHVlcywgdGhlIG51bWJlciBvZiBzZWNvbmRzIHNp bmNlIDE5NzAtMDEtMDEKMDA6MDA6MDAgbG9jYWwgdGltZSZxdW90Ow0KDQpJ IHJhbiBhbiBleHBlcmltZW50LCBpbXBvcnRpbmcgYSB0aW1lc3RhbXAgJiMz OTsyMDE2LTA2LTI2IDIwOjAxOjM4JiMzOTsgd2l0aApkZWZhdWx0IHRpbWUg em9uZSAmIzM5O2xvY2FsdGltZSYjMzk7LCB3aGljaCBpcyBBRVNUIGluIG15 IGNhc2UuDQoNClNFTEVDVCBpZCwgZXh0cmFjdChlcG9jaCBGUk9NIG5vdF9i ZWZvcmUpIEZST00gYmxhOw0KLSZndDsgMTQ2Njk3MTI5OA0KDQpOb3cgSSBz d2l0Y2ggdG8gdGltZXpvbmUgPSAmIzM5O1VUQyYjMzk7IGluIHBvc3RncmVz cWwuY29uZi4gQ29uZmlybWluZyB3aXRoIFNIT1cKVElNRVpPTkUgdGhhdCBJ IGFtIG5vdyBpbiB0aGUgZGVmYXVsdCBVVEMgdGltZXpvbmUgaW4gbXkgc2Vz c2lvbi4gU2FtZQpxdWVyeToNCi0mZ3Q7IDE0NjY5NzEyOTgNCg0KSW4gb3Ro ZXIgd29yZHMsIGl0IHNlZW1zIHRoYXQgdGhlIGZ1bmN0aW9uIGV4dHJhY3Qo ZXBvY2ggZnJvbSB0aW1lc3RhbXApCmNvbnNpZGVyZWQgdGhlIHRpbWVzdGFt cCBmaWVsZCB0byBiZSBpbiBVVEMgaW4gYm90aCBjYXNlcy4gSSBmaW5kIGl0 IGhhcmQgdG8KcmVjb25jaWxlIHRoYXQgd2l0aCB0aGUgZG9jcy4NCg0KQW0g SSBtaXNyZWFkaW5nIHNvbWV0aGluZyBvciBpcyB0aGF0IHNvbWV0aGluZyB0 aGF0IHNob3VsZCBiZSBmaXhlZCBpbiB0aGUKZG9jcz8KCi0tIApTZW50IHZp YSBwZ3NxbC1kb2NzIG1haWxpbmcgbGlzdCAocGdzcWwtZG9jc0Bwb3N0Z3Jl c3FsLm9yZykKVG8gbWFrZSBjaGFuZ2VzIHRvIHlvdXIgc3Vic2NyaXB0aW9u OgpodHRwOi8vd3d3LnBvc3RncmVzcWwub3JnL21haWxwcmVmL3Bnc3FsLWRv Y3MK