From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from [87.239.111.99] (localhost [127.0.0.1]) by dev.tarantool.org (Postfix) with ESMTP id 410566EC55; Sat, 31 Jul 2021 09:32:12 +0300 (MSK) DKIM-Filter: OpenDKIM Filter v2.11.0 dev.tarantool.org 410566EC55 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=tarantool.org; s=dev; t=1627713132; bh=karNVXof8McWcfoC9RQFkvCOArqM/X8ZEdBcD9CjBws=; h=To:Cc:References:Date:In-Reply-To:Subject:List-Id: List-Unsubscribe:List-Archive:List-Post:List-Help:List-Subscribe: From:Reply-To:From; b=fx5JpwcxEIIx/bn7IGRLIfJGUmfMnBquEEKgdkBtuOdUVIxfvvDaAGx9uuWw9VxT6 EU48iWphte2PiC3gOgXaevmW5gQ03nxvImUbe13TcJDuBLsoCGQhPO5pSUtSNkcLbh HqlWiFwq2trMYYhItTbm91nA33WaSNzlYKaxURS4= Received: from smtp61.i.mail.ru (smtp61.i.mail.ru [217.69.128.41]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by dev.tarantool.org (Postfix) with ESMTPS id 5CCC26EC55 for ; Sat, 31 Jul 2021 09:31:37 +0300 (MSK) DKIM-Filter: OpenDKIM Filter v2.11.0 dev.tarantool.org 5CCC26EC55 Received: by smtp61.i.mail.ru with esmtpa (envelope-from ) id 1m9iX2-0004Xs-IV; Sat, 31 Jul 2021 09:31:36 +0300 To: Timur Safin , v.shpilevoy@tarantool.org Cc: tarantool-patches@dev.tarantool.org References: <531544e8-0dd8-8d71-ccfc-4dae2805d498@tarantool.org> <045e01d78598$3ae26e00$b0a74a00$@tarantool.org> Message-ID: Date: Sat, 31 Jul 2021 09:31:36 +0300 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:78.0) Gecko/20100101 Thunderbird/78.12.0 MIME-Version: 1.0 In-Reply-To: <045e01d78598$3ae26e00$b0a74a00$@tarantool.org> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-GB X-7564579A: 646B95376F6C166E X-77F55803: 4F1203BC0FB41BD941C43E597735A9C351B198F4576AC7B2770D7874BA03B4AE182A05F5380850408524AFDAECE198D7F0F53F7A2B72B3FFF34714663B334AFCAEB0AC0D44AC53C5 X-7FA49CB5: FF5795518A3D127A4AD6D5ED66289B5278DA827A17800CE755BE8F535441E38CEA1F7E6F0F101C67BD4B6F7A4D31EC0BCC500DACC3FED6E28638F802B75D45FF8AA50765F790063750E64749F09C4ED58638F802B75D45FF36EB9D2243A4F8B5A6FCA7DBDB1FC311F39EFFDF887939037866D6147AF826D8ED50C7D893F7F35BB157053AB18B9AE5117882F4460429724CE54428C33FAD305F5C1EE8F4F765FC60CDF180582EB8FBA471835C12D1D9774AD6D5ED66289B52BA9C0B312567BB23117882F446042972877693876707352033AC447995A7AD18F04B652EEC242312D2E47CDBA5A96583BA9C0B312567BB2376E601842F6C81A19E625A9149C048EE599709FD55CB46A66B91AC3BD56FC247D8FC6C240DEA7642DBF02ECDB25306B2B78CF848AE20165D0A6AB1C7CE11FEE30A6B3CD6EB70C81876E601842F6C81A1F004C906525384307823802FF610243DF43C7A68FF6260569E8FC8737B5C2249EC8D19AE6D49635B68655334FD4449CB9ECD01F8117BC8BEAAAE862A0553A39223F8577A6DFFEA7CEB8BE9EE02D59E2D43847C11F186F3C59DAA53EE0834AAEE X-C1DE0DAB: 0D63561A33F958A5FE45E1ADAAB4B3D3CA1F3D08A3CB339417F6E448DD866C64D59269BC5F550898D99A6476B3ADF6B47008B74DF8BB9EF7333BD3B22AA88B938A852937E12ACA751B940EDA0DFB0535410CA545F18667F91A7EA1CDA0B5A7A0 X-C8649E89: 4E36BF7865823D7055A7F0CF078B5EC49A30900B95165D34728AF701C68E45399D8661707C837D7A2BEAAB2A74E723782D0406D6F86A411C0085DA296FD61F3C1D7E09C32AA3244C15156D54C9CED5B169DA80E0E8C2A8C0F2F5F14F68F1805BFACE5A9C96DEB163 X-D57D3AED: 3ZO7eAau8CL7WIMRKs4sN3D3tLDjz0dLbV79QFUyzQ2Ujvy7cMT6pYYqY16iZVKkSc3dCLJ7zSJH7+u4VD18S7Vl4ZUrpaVfd2+vE6kuoey4m4VkSEu530nj6fImhcD4MUrOEAnl0W826KZ9Q+tr5ycPtXkTV4k65bRjmOUUP8cvGozZ33TWg5HZplvhhXbhDGzqmQDTd6OAevLeAnq3Ra9uf7zvY2zzsIhlcp/Y7m53TZgf2aB4JOg4gkr2biojNLQ8Cqcv1ivrE0zq5hUSCQ== X-Mailru-Sender: 583F1D7ACE8F49BD1042885CEC987B6BD7F942DBAC011443F0F53F7A2B72B3FFEC9A243AB1C8B1BC7019711D9D5B048E1458020726E2BC9FD5ECBA0B92C0A936CDC7563AA7CEBD287402F9BA4338D657ED14614B50AE0675 X-Mras: Ok Subject: Re: [Tarantool-patches] [PATCH resend v2 10/11] lua, datetime: unixtime, timestamp setters in datetime.lua X-BeenThere: tarantool-patches@dev.tarantool.org X-Mailman-Version: 2.1.34 Precedence: list List-Id: Tarantool development patches List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , From: Oleg Babin via Tarantool-patches Reply-To: Oleg Babin Errors-To: tarantool-patches-bounces@dev.tarantool.org Sender: "Tarantool-patches" On 31.07.2021 02:11, Timur Safin wrote: > Hello Oleg, > > : > : > : Unixtime and timestamp is great but they loss precision. I think it > : should be possible > : > : go get timestamp with nanoseconds precision since datetime has > : nanoseconds precision. > > I'm not quite get it. Do you want to have nanoseconds exported via newindex? > For direct assignments? It's not useful because of available .nsec field. > Or may be you meant something else? > > : > : > : Also still it's hard how to convert timestamp to datetime value back. > > Timestamp is something secs.nsec, what looks complicated? I'm confused. > Could you please elaborate? I expected something like. tarantool> clock.time64() --- - 1627712632369020000 ... This timestamp is in nanoseconds. It's unsigned long long value. I tried to do something for datetime... sec * 1e9 + nsec, but sec is null while nsec is not: ``` tarantool> dt.sec --- - null ... ``` timestamp + nsec works in quite strage way: ``` tarantool> dt.timestamp * (1e9 * 1ULL) + dt.nsec --- - 1627712485108074000 ... ``` (I need to cast to ULL here to avoid precision lost). But maybe my question is not relevant. There is a way to get nanoseconds timestamp. I just need to write some simple helper for my app. It's ok.