Home / Development / What’s the Deal With 12-31-1969?

What’s the Deal With 12-31-1969?

If you’ve been running or developing websites for awhile, you may have run into a problem where a field that should contain a more recent date is instead showing up with the date 12-31-1969. Many people may just recognize this as a problem, get it resolved somehow and move on. But have you ever stopped to wonder just why this specific date is the one that shows up when there’s an issue?

This occurs when data that should be a UNIX timestamp is instead either empty or contains a value of zero. UNIX timestamps are integers that count the number of seconds since midnight on 12-31-1969. As you can imagine, nowadays they’re pretty big.

Sometimes a bug in the software will cause these fields to lose their value — maybe during a software update or database migration — and that’s when you see the epoch date (12-31-1969) instead of the value you were expecting. The good news is the software which is rendering out the timestamp to human readable format is doing its job (a timestamp of zero does correlate to that date). The bad news is you’ve got missing values which are going to have to be tracked down.

So the obvious question is why this particular date? Well it’s very early in UNIX’s history (though this date wasn’t actually chosen until 1972), and basically it just seemed to be a good starting point to begin counting from. It’s amazing how many of the standards we live by today were chosen almost arbitrarily sometime in the past!

About Dave Matteson

David is a Lead Developer at A2 Hosting. He has been writing code professionally for nearly twenty years, and enjoys writing and reading about programming. David does his coding from his house in the woods with his wife and dogs

Check Also

A hand holding contact icons.

How to Create a Quality Contact Page for Your Website (In 5 Steps)

Websites are not only platforms for you to sell your business. They can also be launchpads …