Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eMtDq-00008b-16 for pgsql-sql@arkaria.postgresql.org; Thu, 07 Dec 2017 10:16:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eMtDp-0007jZ-Kf for pgsql-sql@arkaria.postgresql.org; Thu, 07 Dec 2017 10:16:05 +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 1eMtDp-0007jN-DD for pgsql-sql@lists.postgresql.org; Thu, 07 Dec 2017 10:16:05 +0000 Received: from forward100j.mail.yandex.net ([5.45.198.240]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eMtDn-0007ru-58 for pgsql-sql@postgresql.org; Thu, 07 Dec 2017 10:16:04 +0000 Received: from mxback8g.mail.yandex.net (mxback8g.mail.yandex.net [IPv6:2a02:6b8:0:1472:2741:0:8b7:169]) by forward100j.mail.yandex.net (Yandex) with ESMTP id 7B70E5D84D08; Thu, 7 Dec 2017 13:16:00 +0300 (MSK) Received: from web58g.yandex.ru (web58g.yandex.ru [2a02:6b8:0:1402::9c]) by mxback8g.mail.yandex.net (nwsmtp/Yandex) with ESMTP id w0yNoVC3AZ-FxdaELtK; Thu, 07 Dec 2017 13:15:59 +0300 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=reddoc.net; s=mail; t=1512641759; bh=WlV+2eWl8YVC5rNVVt/qY5LwhCIon9pkoIKO9ylHXdk=; h=From:To:In-Reply-To:References:Subject:Message-Id:Date; b=KB38buD3NIA8jmKB+eHBRnjs9Q6gvDODeF6CmEy5xDFRraTx2ymlU0XO4qEEL/dxV CnxFNDnpUTnBGyywTjlx5NOhpjPzSjA6ZjrnpK/G2ISBkjMNeSH0bnpJGD9UmljVxc uL3+l1Tr2SMghP6CykqlkWd4sdHmV3usFteSJVKQ= Authentication-Results: mxback8g.mail.yandex.net; dkim=pass header.i=@reddoc.net Received: by web58g.yandex.ru with HTTP; Thu, 07 Dec 2017 13:15:59 +0300 From: Samed YILDIRIM To: =?utf-8?B?RXJ0YW4gS8O8w6fDvGtvxJ9sdQ==?= , "pgsql-sql@postgresql.org" In-Reply-To: <001c01d36f42$114e5fb0$33eb1f10$@1nar.com.tr> References: <001c01d36f42$114e5fb0$33eb1f10$@1nar.com.tr> Subject: Re: Timestamp alculation identical to Microsoft Excel results MIME-Version: 1.0 Message-Id: <252231512641759@web58g.yandex.ru> X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Thu, 07 Dec 2017 13:15:59 +0300 Content-Transfer-Encoding: base64 Content-Type: text/html; charset=utf-8 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk PGRpdj5IaSBFcnRhbiw8L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5JIHRoaW5rIGZvbGxvd2luZyBx dWVyeSB3b3JrcyBmb3IgeW91LjwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PjxkaXY+cG9zdGdyZXM9 IyBzZWxlY3QgZGF0ZV9wYXJ0KCdlcG9jaCcsICgnMjAxNy0xMS0wMSAxNDo0Nzo0NSc6OnRpbWVz dGFtcCgwKSAtICcyMDE3LTEwLTMxIDEzOjIyOjE3Jzo6dGltZXN0YW1wKDApKS8zNjAwLzI0KTs8 L2Rpdj48ZGl2PsKgZGF0ZV9wYXJ0PC9kaXY+PGRpdj4tLS0tLS0tLS0tLTwvZGl2PjxkaXY+wqAg MS4wNTkzNTI8L2Rpdj48ZGl2PigxIHJvdyk8L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5wb3N0Z3Jl cz0jIHNlbGVjdCBkYXRlX3BhcnQoJ2Vwb2NoJywgKCAnMjAxNy0xMC0zMSAxMzoyMjoxNyc6OnRp bWVzdGFtcCgwKS0nMjAxNy0xMS0wMSAxNDo0Nzo0NSc6OnRpbWVzdGFtcCgwKSkvMzYwMC8yNCk7 PC9kaXY+PGRpdj7CoGRhdGVfcGFydDwvZGl2PjxkaXY+LS0tLS0tLS0tLS08L2Rpdj48ZGl2PsKg LTEuMDU5MzUyPC9kaXY+PGRpdj4oMSByb3cpPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+QmVzdCBy ZWdhcmRzLjwvZGl2PjwvZGl2PjxkaXY+xLB5aSDDp2FsxLHFn21hbGFyLjwvZGl2PjxkaXY+U2Ft ZWQgWUlMRElSSU08L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+MDcuMTIuMjAx NywgMTI6NTksICJFcnRhbiBLw7zDp8O8a2/En2x1IiAmbHQ7ZXJ0YW4ua3VjdWtvZ2x1QDFuYXIu Y29tLnRyJmd0Ozo8L2Rpdj48YmxvY2txdW90ZSB0eXBlPSJjaXRlIj48cD5IZWxsbyw8YnIgLz48 YnIgLz5UaGVyZSBpcyB0aGlzIEV4Y2VsIHJlcG9ydCB3aGljaCB3aWxsIGJlIHByb2R1Y2VkIGJ5 IGFuIGFwcGxpY2F0aW9uLiBJbjxiciAvPkV4Y2VsLCB0aGVyZSBpcyBiZWxvdyBlcXVhdGlvbjxi ciAvPjMxLzEwLzIwMTcgMTU6MDUgLSAzMS8xMC8yMDE3IDE0OjM2OjAwID0gMDoyODoyMTxiciAv PjxzcGFuPjIwMTctMTAtMzEgMTM8L3NwYW4+OjIyOjxzcGFuPjE3IC0gMjAxNy0xMS0wMSAxNDwv c3Bhbj46NDc6NDUgPSAxLzEvMTkwMCAwMToyNTxiciAvPjxiciAvPlRoYXQgaXMgdmVyeSBzaW1w bGUgaW4gUG9zdGdyZVNRTC4gU2ltcGx5IHN1YnRyYWN0IHR3byB0aW1lc3RhbXAgd2l0aG91dDxi ciAvPnRpbWUgem9uZSBmaWVsZHMgYW5kIHlvdSBoYXZlIHRoZSByZXN1bHQuIEhvd2V2ZXIsIEV4 Y2VsIGFsc28gcmVwcmVzZW50IHRoYXQ8YnIgLz5yZXN1bHQgMDoyODoyMSBhcyBkb3VibGUgbm90 YXRpb24gMC48c3Bhbj4wMTk2ODc0OTk5OTY1MDc1PC9zcGFuPiBhbmQgMS8xLzE5MDAgMDE6MjUg YXM8YnIgLz4xLDxzcGFuPjA1OTM1MTg1MTg1MDgxPC9zcGFuPi48YnIgLz48YnIgLz5JIGNvdWxk IG5vdCBzZWUgYW55IHdheSB0byBoYXZlIHNhbWUgdmFsdWVzIHVzaW5nIFBvc3RncmVTUUwgcXVl cnkuIEkgdHJpZWQ6PGJyIC8+ZXh0cmFjdChlcG9jaCBmcm9tIHRpbWVfZmllbGQyKSAtIGV4dHJh Y3QoZXBvY2ggZnJvbSB0aW1lX2ZpZWxkMSkgYW5kIHJlc3VsdDxiciAvPmlzIDE3MDEgYW5kIDUx MjggcmVzcGVjdGl2ZWx5LjxiciAvPjxiciAvPlB1dHRpbmcgYXNpZGUgcmVhc29ucyBhcyB0byB3 aHkgbnVtYmVycyBhcmUgdXNlZCBpbnN0ZWFkIG9mIG1vcmUgaHVtYW48YnIgLz51bmRlcnN0YW5k YWJsZSB0aW1lIGZvcm1hdCwgSSB3b3VsZCBsaWtlIHRvIGxlYXJuIGlmIGhhdmluZyBzYW1lIHJl c3VsdHMgYXM8YnIgLz5FeGNlbCBpcyBwb3NzaWJsZS48YnIgLz48YnIgLz5UaGFua3MgJmFtcDsg cmVnYXJkcyw8YnIgLz5FcnRhbiBLw7zDp8O8a2/En2x1PGJyIC8+PGJyIC8+PGJyIC8+PGJyIC8+ PGJyIC8+PGJyIC8+wqA8L3A+PC9ibG9ja3F1b3RlPg==