From mboxrd@z Thu Jan 1 00:00:00 1970 X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on inbox.vuxu.org X-Spam-Level: X-Spam-Status: No, score=-0.8 required=5.0 tests=DKIM_INVALID,DKIM_SIGNED, MAILING_LIST_MULTI,T_SCC_BODY_TEXT_LINE autolearn=ham autolearn_force=no version=3.4.4 Received: (qmail 31895 invoked from network); 9 Sep 2022 03:30:21 -0000 Received: from minnie.tuhs.org (50.116.15.146) by inbox.vuxu.org with ESMTPUTF8; 9 Sep 2022 03:30:21 -0000 Received: from minnie.tuhs.org (localhost [IPv6:::1]) by minnie.tuhs.org (Postfix) with ESMTP id 9BBC0428EF; Fri, 9 Sep 2022 13:30:15 +1000 (AEST) Received: from wout2-smtp.messagingengine.com (wout2-smtp.messagingengine.com [64.147.123.25]) by minnie.tuhs.org (Postfix) with ESMTPS id 9BCB9428EE for ; Fri, 9 Sep 2022 13:30:10 +1000 (AEST) Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id 89DFC320090A for ; Thu, 8 Sep 2022 23:30:09 -0400 (EDT) Received: from imap47 ([10.202.2.97]) by compute4.internal (MEProxy); Thu, 08 Sep 2022 23:30:09 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=loomcom.com; h= cc:content-type:date:date:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to; s=fm1; t=1662694209; x=1662780609; bh=9ttt3gBKOL lw/9M6RzTYC0a9T4Bc3t8vsXG/jzng3F4=; b=DhUgdquZipysdnvOJKKs1/FGZm F1HY1st0UYlFfyg3OMAz13yqFPca9MbjbLBlnWUfq5O/p0O8fanaEq1MrQP4pSn/ Xrm5xsZw4ZSbzKv7es7Urg7DWaCBzZuEuK3yIRBq6DfPwYP1fa6Nvq38XffRORsX j/Ba1t94GC69dm5LzOG1VOQFvrpHRsQ2FTiyRjBJUTGktKhs7LWqboxmxy7FyTua jp9Zg2hjbbnMHZwv4uVE9o/z3zLsQ4uGbLmP+D4pcQok8g79CwtUPVo/3u/6q2ww 9UhZ7+EoqCHz55CUiciz2Ezc0V5DjTjmywrq/LewkJKf3dhPUw5KgECYslyQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:date:feedback-id :feedback-id:from:from:in-reply-to:in-reply-to:message-id :mime-version:references:reply-to:sender:subject:subject:to:to :x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; t=1662694209; x=1662780609; bh=9ttt3gBKOLlw/9M6RzTYC0a9T4Bc 3t8vsXG/jzng3F4=; b=k7WXDsuotOwWXtfKF5IJ78gkJlwXoBHQJo3KpQFFtzvT JGKs78ZEUEEC/nAq0fEz1WoZkxfbIsUIzKUivTcaziQLB8aEhwTf9pims3csRxGM Fnm5VJK9gDhK/pfHMOZu6hPRn91r9a4GUxoUntfB38ZFcB4/Ub4kry+XH5gpqJ9F WztvuVy1mBOjK4gIJbB97VJIwIRWuYO4b0wgmpprpKvUMXOtL5G+SUhfLpLIZwFb ZfEiZv7iWyu6Zo2ZbPAu7287dnTV4g6KkwKvy1JgbOsqup3slsuvq0QHdnD4orBT zPm2DCjGj1LJOfePcvovI9BEzk4kNi1dlTx9lSmckQ== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvfedrfedtgedgjedvucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucenucfjughrpefofgggkfgjfhffhffvufgtsehttd ertderredtnecuhfhrohhmpedfufgvthhhucfoohhrrggsihhtohdfuceofigvsgeslhho ohhmtghomhdrtghomheqnecuggftrfgrthhtvghrnhepjeduhedtgfffkeffvedtkeevfe egveelhefgjeduleekhfeihfduleeuheehuefhnecuffhomhgrihhnpehtihhmvggrnhgu uggrthgvrdgtohhmnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilh hfrhhomhepfigvsgeslhhoohhmtghomhdrtghomh X-ME-Proxy: Feedback-ID: i132042c1:Fastmail Received: by mailuser.nyi.internal (Postfix, from userid 501) id BF44DA6007C; Thu, 8 Sep 2022 23:30:08 -0400 (EDT) X-Mailer: MessagingEngine.com Webmail Interface User-Agent: Cyrus-JMAP/3.7.0-alpha0-927-gf4c98c8499-fm-20220826.002-gf4c98c84 Mime-Version: 1.0 Message-Id: <22fb8110-9d31-4025-a4ab-73eb643a99d1@www.fastmail.com> In-Reply-To: References: Date: Thu, 08 Sep 2022 20:29:36 -0700 From: "Seth Morabito" To: tuhs@tuhs.org Content-Type: text/plain Message-ID-Hash: F45KUG7QYDBCOO7CXDFPVU3O66TGKZEJ X-Message-ID-Hash: F45KUG7QYDBCOO7CXDFPVU3O66TGKZEJ X-MailFrom: web@loomcom.com X-Mailman-Rule-Misses: dmarc-mitigation; no-senders; approved; emergency; loop; banned-address; member-moderation; header-match-tuhs.tuhs.org-0; nonmember-moderation; administrivia; implicit-dest; max-recipients; max-size; news-moderation; no-subject; digests; suspicious-header X-Mailman-Version: 3.3.6b1 Precedence: list Subject: [TUHS] Re: Happy birthday, Unix timestamp! List-Id: The Unix Heritage Society mailing list Archived-At: List-Archive: List-Help: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: On Thu, Sep 8, 2022, at 3:28 PM, Dave Horsfall wrote: > https://www.timeanddate.com/on-this-day/september/9 > > ``Unix time or Unix epoch, POSIX time or Unix timestamp, is a time system > that measures the number of seconds since midnight UTC of January 1, 1970, > not counting leap seconds. At 01:46:40 UTC on September 9, 2001, Unix time > reached the billionth second timestamp.'' I remember this event vividly because at work we had an important system fail. There was a database that was storing the time into a VARCHAR column. Unfortunately, we were sorting on that column and using the table as a queue so we could always be sure to pick up the most recent entries and act on them. Well, you can imagine what happened when the leading digit changed from an ASCII "9" to an ASCII "1". Oops. -Seth -- Seth Morabito Poulsbo, WA web@loomcom.com