From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: tomas@tuxteam.de Newsgroups: gmane.emacs.help Subject: Re: How to format this type of timestamp Date: Mon, 5 Oct 2020 12:34:11 +0200 Message-ID: <20201005103411.GA27174@tuxteam.de> References: <20201003115510.GH32715@protected.rcdrun.com> <83pn5zfqik.fsf@gnu.org> <20201004042834.GJ32715@protected.rcdrun.com> <20201004074733.GA25970@tuxteam.de> <20201004140803.GB15516@protected.rcdrun.com> <20201004150117.GA9423@tuxteam.de> <20201004165940.GC15516@protected.rcdrun.com> <20201005090540.GD4453@protected.rcdrun.com> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="5vNYLRcllDrimb99" Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="19562"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Mutt/1.5.21 (2010-09-15) Cc: help-gnu-emacs , Yuri Khan To: Jean Louis Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane-mx.org@gnu.org Mon Oct 05 12:36:34 2020 Return-path: Envelope-to: geh-help-gnu-emacs@m.gmane-mx.org Original-Received: from lists.gnu.org ([209.51.188.17]) by ciao.gmane.io with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kPNr7-0004yP-Sd for geh-help-gnu-emacs@m.gmane-mx.org; Mon, 05 Oct 2020 12:36:33 +0200 Original-Received: from localhost ([::1]:40350 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kPNr6-000309-Ud for geh-help-gnu-emacs@m.gmane-mx.org; Mon, 05 Oct 2020 06:36:32 -0400 Original-Received: from eggs.gnu.org ([2001:470:142:3::10]:36356) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kPNp8-0002Ez-U8 for help-gnu-emacs@gnu.org; Mon, 05 Oct 2020 06:34:30 -0400 Original-Received: from mail.tuxteam.de ([5.199.139.25]:46742) by eggs.gnu.org with esmtps (TLS1.2:DHE_RSA_AES_128_CBC_SHA1:128) (Exim 4.90_1) (envelope-from ) id 1kPNp6-0007jg-Go for help-gnu-emacs@gnu.org; Mon, 05 Oct 2020 06:34:30 -0400 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=tuxteam.de; s=mail; h=In-Reply-To:Content-Type:MIME-Version:References:Message-ID:Subject:Cc:To:From:Date; bh=f6CMQoFTkF5eaDJw96QIaOjB70ptwzAirxanthPFl2Y=; b=FoeRKsDAEkiRJYQwS7h2wXDjMV3b2Cbh8pwcXUB5EAH6wbpxqJa6G8wiEnwwjh2qJ9spUyKV9n1Z8TLlMciTy3JiWQCrwLQIN8TlSXC7aDb/fAqTry9bqgM6jBWxZdocy70FtkI7h3U1i7KJNu4+aB6eyui5Q7twVi31viKcjNw43+9Mh5pz7ntJK0lZFS2k4mvwl85bKyltWnSO8Wd9GXXHl2bnoaYswIcZq4EqeDt/gg0TxCiM3bTl8jOqvuIlaI9iNoNMSap2+f2SRpcyHBZiu7Ja5vepysr41/8UYIyK3AijvcAOUGFZmrjOXk9PmOerv3XK5AB7V67Dri2WTA==; Original-Received: from tomas by mail.tuxteam.de with local (Exim 4.80) (envelope-from ) id 1kPNop-0007Aw-Uw; Mon, 05 Oct 2020 12:34:12 +0200 Content-Disposition: inline In-Reply-To: <20201005090540.GD4453@protected.rcdrun.com> Received-SPF: pass client-ip=5.199.139.25; envelope-from=tomas@tuxteam.de; helo=mail.tuxteam.de X-detected-operating-system: by eggs.gnu.org: First seen = 2020/10/05 06:34:19 X-ACL-Warn: Detected OS = Linux 3.1-3.10 [fuzzy] X-Spam_score_int: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: help-gnu-emacs@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Users list for the GNU Emacs text editor List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane-mx.org@gnu.org Original-Sender: "help-gnu-emacs" Xref: news.gmane.io gmane.emacs.help:124315 Archived-At: --5vNYLRcllDrimb99 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Mon, Oct 05, 2020 at 12:05:40PM +0300, Jean Louis wrote: > * Yuri Khan [2020-10-04 21:42]: > > I think tomas=E2=80=99s remark was about the fact that you hardcode +03= in > > your format string but you let Emacs auto-detect your local time zone. > > This can cause an inconsistency if it detects a zone other than +03. > > Two better options would be: > >=20 > > a. Let Emacs auto-detect the time zone and use the %Z format specifier > > to preserve the detected time zone in the string. > >=20 > > (format-time-string "%F %T.%6N%Z" (/ 1599549641372 1000.0)) > > =E2=87=92 "2020-09-08 14:20:41.371999+07" >=20 > Thank you. >=20 > It is not good to hard code in my specific case, and also not good to > assume the default local time zone as messages are coming from various > countries in various time zones, it is not practical that I assume my > local time zone, so I am waiting for the answer from developers of > Silence SMS application, as maybe the time is UTC time, then it will > be alright, then I can convert it properly to PostgreSQL timestamp > with time zone. I think you don't need that response. They'd be foolish to have a purely numerical timestamp be other than "seconds [1] from Epoch, in UTC", where Epoch is 1970-01-01 (well Mac has Epoch on 1900-01-01: whether that's foolish is left as an exercise to the reader). Simply because there's no means to communicate. Typically when /displaying/ the date to a human reader, you pick this human reader's timezone (or whatever you guess her timezone is). Cheers [1] well, milliseconds in your case. Thank Java for it! - t --5vNYLRcllDrimb99 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.12 (GNU/Linux) iEYEARECAAYFAl969qMACgkQBcgs9XrR2kZQHgCePX+lrT2vIbn66VsqVkfRAETt K5AAnjyiZA21QZAncAULNV0yKZEZ25UH =C74N -----END PGP SIGNATURE----- --5vNYLRcllDrimb99--