From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Jean Louis Newsgroups: gmane.emacs.help Subject: Re: even elder races get tired of waiting Date: Sun, 21 Mar 2021 17:01:33 +0300 Message-ID: References: <87v99lr26w.fsf@zoho.eu> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="29097"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Mutt/2.0.6 (2021-03-06) To: help-gnu-emacs@gnu.org Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane-mx.org@gnu.org Sun Mar 21 15:03:07 2021 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 1lNyfb-0007P8-6f for geh-help-gnu-emacs@m.gmane-mx.org; Sun, 21 Mar 2021 15:03:07 +0100 Original-Received: from localhost ([::1]:34124 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1lNyfa-0000Cr-6b for geh-help-gnu-emacs@m.gmane-mx.org; Sun, 21 Mar 2021 10:03:06 -0400 Original-Received: from eggs.gnu.org ([2001:470:142:3::10]:55422) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1lNyfG-0000B8-1Z for help-gnu-emacs@gnu.org; Sun, 21 Mar 2021 10:02:46 -0400 Original-Received: from stw1.rcdrun.com ([217.170.207.13]:52997) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1lNyfD-0007wX-Iu for help-gnu-emacs@gnu.org; Sun, 21 Mar 2021 10:02:45 -0400 Original-Received: from localhost ([::ffff:41.202.241.53]) (AUTH: PLAIN securesender, TLS: TLS1.3,256bits,ECDHE_RSA_AES_256_GCM_SHA384) by stw1.rcdrun.com with ESMTPSA id 000000000001E082.0000000060575200.000055C5; Sun, 21 Mar 2021 07:02:39 -0700 Mail-Followup-To: help-gnu-emacs@gnu.org Content-Disposition: inline In-Reply-To: <87v99lr26w.fsf@zoho.eu> Received-SPF: pass client-ip=217.170.207.13; envelope-from=bugs@gnu.support; helo=stw1.rcdrun.com X-Spam_score_int: -18 X-Spam_score: -1.9 X-Spam_bar: - X-Spam_report: (-1.9 / 5.0 requ) BAYES_00=-1.9, SPF_HELO_PASS=-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:128472 Archived-At: * Emanuel Berg via Users list for the GNU Emacs text editor [2021-03-20 23:39]: > ;;; this file: > ;;; http://user.it.uu.se/~embe8573/emacs-init/time-cmp.el > ;;; https://dataswamp.org/~incal/emacs-init/time-cmp.el > > ;; ... > > (require 'cl-lib) > (defun days-from-date (d1 d2) > (let*((sep "-") > (d1-data (cl-map 'list #'string-to-number (split-string d1 sep))) > (d2-data (cl-map 'list #'string-to-number (split-string d2 sep))) > (y1 (car d1-data)) > (m1 (cadr d1-data)) > (d1 (caddr d1-data)) > (y2 (car d2-data)) > (m2 (cadr d2-data)) > (d2 (caddr d2-data)) ) > (days-from y1 m1 d1 y2 m2 d2) )) > ;; (days-from-date "2021-03-19" "2021-04-20") ; 31 > > (defun days-from (y1 m1 d1 y2 m2 d2) > (let*((s-then (float-time (encode-time 0 0 0 d1 m1 y1))) > (s-now (float-time (encode-time 0 0 0 d2 m2 y2))) > (s-diff (- s-now s-then)) ) > (string-to-number (format-seconds "%d" s-diff) ))) > ;; (days-from 2021 03 19 2021 04 20) ; 31 Great. I use PostgreSQL for that, and there is difference one day: (defun days-from (from-date to-date) "Returns days passed from FROM-DATE to TO-DATE in format YYYY-MM-DD." (string-to-number (string-trim (shell-command-to-string (format "psql -Aqtc \"SELECT abs('%s'::date - '%s'::date)\"" to-date from-date))))) (days-from "2021-03-19" "2021-04-20") => 32 Also here they claim to be 32: https://www.timeanddate.com/date/durationresult.html?d1=19&m1=03&y1=2021&d2=20&m2=04&y2=2021 And if I click on that website [X] Include end date in calculation, I get 33. Maybe website is wrong. Human review: March 2021 April 2021 Su Mo Tu We Th Fr Sa Su Mo Tu We Th Fr Sa 1 2 3 4 5 6 1 2 3 7 8 9 10 11 12 13 4 5 6 7 8 9 10 14 15 16 17 18 19 20 11 12 13 14 15 16 17 21 22 23 24 25 26 27 18 19 20 21 22 23 24 28 29 30 31 25 26 27 28 29 30 20 21 22 23 24 25 26 27 28 29 30 31 plus 20 = 32 So it is maybe matter of counting. I don't count the first day, as that is like zero. But I do count last day. Website says 33 if last day is counted. So in the end your difference of 31 is maybe right. Jean