I'm a char salesmen. I share things about; Programming, SysOps, Civil Rights, education, and things that make me happy. And robots.
1467 stories
·
18 followers

Historical Dates

3 Comments and 11 Shares
Evidence suggests the 1899 transactions occurred as part of a global event centered around a deity associated with the lotus flower.
Read the whole story
reconbot
1 day ago
reply
New York City
Share this story
Delete
3 public comments
ghafarkkali
3 days ago
reply
KooKoo Kids is the best kidswear clothing brand in Pakistan that offers online clothes for girls and boys from 1 to 12 years old. Grab now with up to 60% off. Visit our website https://thekookookids.com
JayM
10 days ago
reply
Hahaha. Yep.
Atlanta, GA
Screwtape
10 days ago
reply
An explanation, for those as puzzled as I was:

Unix-based systems traditionally represent timestamps as "seconds since 1970-01-01". If some program requires a modification timestamp for some file and no accurate value is available, it will commonly use the value 0 as a default. When other systems carefully preserve that value, it leads to files with 1970-01-01 timestamp.

Spreadsheets traditionally represent timestamps as "(fractional) days since 1900-01-01". In the same way, asking for a timestamp when no valid information is available will often get the value 0 as a default. Since businesses run on Excel, there's a lot of transaction records with a 0 timestamp in Excel spreadsheets out there.

One last wrinkle: The first wildly popular spreadsheet, Lotus 1-2-3, had a bug: it assumed that the year 1900 was a leap year, so it assumed 1900-02-29 existed, and so every date timestamp after that point was off by one. When Microsoft created Excel, they carefully reimplemented that bug for compatibility's sake, but if you're a historian looking at the data, you might reasonable assume that spreadsheets stored timestamps as "(fractional) days since 1899-12-31". If you're storing timestamps in some different format, it might not be obvious that those are zero dates - you might assume there's just a lot of transactions processed on that day.
martinbaum
10 days ago
Staggeringly thorough, thank you!
rraszews
8 days ago
I knew the 1970 thing but didn't understand the provenance of the 1899 one; I assumed it had something to do with the Y2K bug (as a colleage of mine put it, "1899 and 1999 were two very different years, but they had one thing in common: the next year would be 1900")

Favorite Things

4 Shares
Read the whole story
reconbot
51 days ago
reply
New York City
Share this story
Delete

The Best Camera

9 Shares
The best camera is the one at L2.
Read the whole story
digdoug
82 days ago
reply
Louisville, KY
reconbot
83 days ago
reply
New York City
Share this story
Delete

The Universe by Scientific Field

1 Comment and 4 Shares
The math and philosophy people also claim everything, but the astronomers argue that the stuff they study really only comprises a small number of paper surfaces.
Read the whole story
reconbot
85 days ago
reply
New York City
Share this story
Delete
1 public comment
JayM
95 days ago
reply
hahaha
Atlanta, GA

Maybe

3 Shares
Read the whole story
reconbot
159 days ago
reply
New York City
Share this story
Delete

Data Trap

3 Comments and 13 Shares
It's important to make sure your analysis destroys as much information as it produces.
Read the whole story
reconbot
223 days ago
reply
New York City
Share this story
Delete
3 public comments
sahand111
224 days ago
reply
آیا از خدمات پرینت سه بعدی چیزی می دانید؟
https://arli3d.com/3d-design-services/
ReadLots
229 days ago
reply
Does sharing this post make more data?
rgloeckner
230 days ago
reply
Good advice - destroy data. Start with that tracking nightmare
Next Page of Stories