The Unix Heritage Society mailing list
 help / color / mirror / Atom feed
From: "Seth Morabito" <>
Subject: [TUHS] Re: Happy birthday, Unix timestamp!
Date: Thu, 08 Sep 2022 20:29:36 -0700	[thread overview]
Message-ID: <> (raw)
In-Reply-To: <>

On Thu, Sep 8, 2022, at 3:28 PM, Dave Horsfall wrote:
> ``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 Morabito
  Poulsbo, WA

  parent reply	other threads:[~2022-09-09  3:30 UTC|newest]

Thread overview: 10+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2022-09-08 22:28 [TUHS] " Dave Horsfall
2022-09-08 23:48 ` [TUHS] " Rob Pike
2022-09-09  0:11   ` Dan Cross
2022-09-09  4:24   ` Rob Pike
2022-09-11  0:09   ` Dave Horsfall
2022-09-09  3:29 ` Seth Morabito [this message]
2022-09-09  7:03   ` Michael Kjörling
2022-09-09 12:06 Douglas McIlroy
2022-09-09 17:16 ` Andrew Hume
2022-09-09 18:53 Norman Wilson

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \ \ \ \

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for NNTP newsgroup(s).