Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««12345»»

T-SQL Expand / Collapse
Author
Message
Posted Wednesday, December 15, 2010 8:45 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 24, 2013 9:59 PM
Points: 1,354, Visits: 1,299
OCTom (12/15/2010)
The Y2K rush was exciting, boring, tedious, scary...

This question does make one wonder why 2-digit years are still in use. However, since SQL Server dates only go out to 12-31-9999, we should get ready for y10k soon.

Thanks for bringing back the memories.


Not necessary. According to some people, the Mayan calendar shows the world will end on December 21, 2012 anyway.

http://en.wikipedia.org/wiki/2012_phenomenon
Post #1035614
Posted Thursday, December 16, 2010 1:49 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:00 AM
Points: 2,562, Visits: 2,420
the Mayan calendar shows the world will end on December 21, 2012 anyway.

Mayan calendar BUG: 12/12/2012 is the end.

Post #1035688
Posted Thursday, December 16, 2010 3:20 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 24, 2013 9:59 PM
Points: 1,354, Visits: 1,299
Carlo Romagnano (12/16/2010)
the Mayan calendar shows the world will end on December 21, 2012 anyway.

Mayan calendar BUG: 12/12/2012 is the end.


Actually, it's 12/21/2012
Post #1035718
Posted Thursday, December 16, 2010 3:36 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:00 AM
Points: 2,562, Visits: 2,420
cengland0 (12/16/2010)
Carlo Romagnano (12/16/2010)
the Mayan calendar shows the world will end on December 21, 2012 anyway.

Mayan calendar BUG: 12/12/2012 is the end.


Actually, it's 12/21/2012

It depends on "Regional Settings".
Post #1035725
Posted Thursday, December 16, 2010 3:41 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 24, 2013 9:59 PM
Points: 1,354, Visits: 1,299
Carlo Romagnano (12/16/2010)
cengland0 (12/16/2010)
Carlo Romagnano (12/16/2010)
the Mayan calendar shows the world will end on December 21, 2012 anyway.

Mayan calendar BUG: 12/12/2012 is the end.


Actually, it's 12/21/2012

It depends on "Regional Settings".

I hope you're kidding because I know of settings that can change from mm/dd/yyyy to dd/mm/yyyy or yyyy/mm/dd but none that will change a 21 to a 12.
Post #1035729
Posted Thursday, December 16, 2010 9:41 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 28, 2014 8:53 PM
Points: 1,388, Visits: 3,039
cengland0 (12/16/2010)
Carlo Romagnano (12/16/2010)
cengland0 (12/16/2010)
Carlo Romagnano (12/16/2010)
the Mayan calendar shows the world will end on December 21, 2012 anyway.

Mayan calendar BUG: 12/12/2012 is the end.


Actually, it's 12/21/2012

It depends on "Regional Settings".

I hope you're kidding because I know of settings that can change from mm/dd/yyyy to dd/mm/yyyy or yyyy/mm/dd but none that will change a 21 to a 12.

There could be a super-secret release that offers the expression of a day number in base nineteen.
Post #1035942
Posted Thursday, December 16, 2010 11:21 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 24, 2013 9:59 PM
Points: 1,354, Visits: 1,299
john.arnott (12/16/2010)

There could be a super-secret release that offers the expression of a day number in base nineteen.

I did some research on the Mayan calendar and it seems they used a base 20 numbering system. Very interesting. Also, They had two calendars. One was 260 days long (13 * 20) and the other was 360 (18 * 20) plus 5 bad luck days at the end of the year. That gave them 365 days total for each year. Unfortunately they didn't account for the extra quarter day (.256) each year (leap years) so after a couple centuries, their calendars would have been all messed up and no longer tied to the seasons properly.

I'm still curious what the 260 day calendar was for. There are some good theories and the best one is for the pregnancy cycles. It is 260 days from the first missed period to the birth of the child. We currently use a 280 day cycle (40 weeks) but that is from the date of the last period instead of the missed period.

Now, they discovered another Mayan calendar that uses 819 days. I cannot find any reason for this number of days. I thought it could be other planet orbits but Mars takes 686.95 days and Jupiter 4337. The 819 falls in between. Anyone else have any clue what they would count 819 days for?
Post #1036016
Posted Thursday, December 16, 2010 12:15 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:17 AM
Points: 13,085, Visits: 12,549
cengland0 (12/16/2010)
john.arnott (12/16/2010)

There could be a super-secret release that offers the expression of a day number in base nineteen.

I did some research on the Mayan calendar and it seems they used a base 20 numbering system. Very interesting. Also, They had two calendars. One was 260 days long (13 * 20) and the other was 360 (18 * 20) plus 5 bad luck days at the end of the year. That gave them 365 days total for each year. Unfortunately they didn't account for the extra quarter day (.256) each year (leap years) so after a couple centuries, their calendars would have been all messed up and no longer tied to the seasons properly.

I'm still curious what the 260 day calendar was for. There are some good theories and the best one is for the pregnancy cycles. It is 260 days from the first missed period to the birth of the child. We currently use a 280 day cycle (40 weeks) but that is from the date of the last period instead of the missed period.

Now, they discovered another Mayan calendar that uses 819 days. I cannot find any reason for this number of days. I thought it could be other planet orbits but Mars takes 686.95 days and Jupiter 4337. The 819 falls in between. Anyone else have any clue what they would count 819 days for?


Several speculations are that 819 = 7 * 9 * 13. There 13 Gods of the heavens, 9 of the underworld and 7 of the earth.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1036049
Posted Thursday, December 16, 2010 6:18 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:57 AM
Points: 7,801, Visits: 9,551
nice clear unambiguous question. Thanks.

Tom
Post #1036246
Posted Friday, December 17, 2010 1:06 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:00 AM
Points: 2,562, Visits: 2,420
There could be a super-secret release that offers the expression of a day number in base nineteen.

The date 21 december 2012 depends on the fact that mayan DBA are still using Slqserver sybase 1.0 and the datetime is limited to 21 december 2012.
We are using sqlserver 2008 R2 and datetime limit is 31 december 9999 (next real end of world).
Post #1036363
« Prev Topic | Next Topic »

Add to briefcase «««12345»»

Permissions Expand / Collapse