SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


T-SQL


T-SQL

Author
Message
cengland0
cengland0
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1676 Visits: 1300
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
Carlo Romagnano
Carlo Romagnano
SSCarpal Tunnel
SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)

Group: General Forum Members
Points: 4870 Visits: 3326
the Mayan calendar shows the world will end on December 21, 2012 anyway.

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

I run on tuttopodismo
cengland0
cengland0
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1676 Visits: 1300
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.
:-D:-D:-D

Actually, it's 12/21/2012
Carlo Romagnano
Carlo Romagnano
SSCarpal Tunnel
SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)

Group: General Forum Members
Points: 4870 Visits: 3326
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.
:-D:-D:-D

Actually, it's 12/21/2012

It depends on "Regional Settings".
:-D:-D:-D:-D

I run on tuttopodismo
cengland0
cengland0
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1676 Visits: 1300
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.
:-D:-D:-D

Actually, it's 12/21/2012

It depends on "Regional Settings".
:-D:-D:-D:-D

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.
john.arnott
john.arnott
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: General Forum Members
Points: 1960 Visits: 3059
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.
:-D:-D:-D

Actually, it's 12/21/2012

It depends on "Regional Settings".
:-D:-D:-D:-D

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.;-)Hehe:-D:-)
cengland0
cengland0
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1676 Visits: 1300
john.arnott (12/16/2010)

There could be a super-secret release that offers the expression of a day number in base nineteen.;-)Hehe:-D:-)

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?
Sean Lange
Sean Lange
One Orange Chip
One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)

Group: General Forum Members
Points: 25906 Visits: 17519
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.;-)Hehe:-D:-)

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 Modens 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)
TomThomson
TomThomson
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14224 Visits: 12197
nice clear unambiguous question. Thanks.

Tom

Carlo Romagnano
Carlo Romagnano
SSCarpal Tunnel
SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)

Group: General Forum Members
Points: 4870 Visits: 3326
There could be a super-secret release that offers the expression of a day number in base nineteen.;-)Hehe:-D:-)

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).

I run on tuttopodismo
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search