40,000 days since the beginning of ‘time’

Next Tuesday feels like a significant day. Not only is it 7/7, and the fourth anniversary of the London bombings (in 2005), but it’s 40,000 days since the beginning of time. Well, not proper time, but since the start of the 1900s.

SELECT DATEDIFF(day,'19000101','20090707')+1 AS DaysOf1900s

So if Day 1 is Jan 1, 1900 (as many systems tend to use – SQL actually considers it Day 0), Day 40000 is 7/7/2009.

I actually rate the start of the twentieth century as a very significant event in the human race. In 1900 the world was changing faster than it had ever done before, and no-one can deny the significance of the twentieth century in history. I’m sure change will continue to become faster, but I found it interesting recently when I noticed that we were approaching this ‘milestone’ of sorts.

Published Wed, Jul 1 2009 11:12 by Rob Farley
Filed under: ,

Comments

Tuesday, June 30, 2009 7:26 PM by Microsoft and DiscountASP.NET news

# 40,000 days since the beginning of ‘time’

This is cool...A SQL Server trip through the 1900's by Rob Farley: 40,000 days since the beginning of

Sunday, July 05, 2009 6:11 AM by Rob Farley

# Excel dates counted differently and a reliable way of working out the day of the week

Following my recent post about 40,000 days , I got a couple of emails telling me that Excel disagrees