Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

 DATETIME - 3 Rate Topic Display Mode Topic Options
Author
 Message
 Posted Monday, March 11, 2013 10:37 AM
 SSCommitted Group: General Forum Members Last Login: Friday, September 16, 2016 10:22 AM Points: 1,574, Visits: 2,958
 honza.mf (3/11/2013)wolfkillj (3/11/2013)I think Microsoft made its explanation of how the cutoff year functions more confusing by using the word "century". In my mind, and I suspect many others think the same way since this seems to be the most common usage, the word "century" denotes a 100-year period beginning on a year evenly divisible by 100, e.g. 1900 - 1999, 2000 - 2099. Thus, I might have decided that a two-digit year value of 65, being in the same "century" as the default cutoff year of 2049 (i.e., 2000-2099) would mean 2065. Microsoft could have made the explanation clearer by specifying that "a two-digit year value is interpreted as being within the 100-year period ending with the cutoff year." That would make it crystal clear to me that a cutoff year of 2049 means that two-digit year values will be deemed to represent years 1950 - 2049 while a cutoff year of 2074 would mean that two-digit year values will be deemed to represent years 1975 - 2074, etc.Are you sure a century is 1900-1999? I think a century is 1901-2000.I see what you mean... but as the default year starts with 1900 in the SQL I guess what wolfkillj meant might be has to do with this... from 1900 (100 years, including 1900) will be 1999, so 2000 (including 2000) for next century will 2000-2099.(sorry to burst in between) ww; Raghu--The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
Post #1429392
 Posted Monday, March 11, 2013 11:57 AM
 Ten Centuries Group: General Forum Members Last Login: Monday, August 24, 2015 12:20 PM Points: 1,064, Visits: 2,582
 Raghavendra Mudugal (3/11/2013)honza.mf (3/11/2013)wolfkillj (3/11/2013)I think Microsoft made its explanation of how the cutoff year functions more confusing by using the word "century". In my mind, and I suspect many others think the same way since this seems to be the most common usage, the word "century" denotes a 100-year period beginning on a year evenly divisible by 100, e.g. 1900 - 1999, 2000 - 2099. Thus, I might have decided that a two-digit year value of 65, being in the same "century" as the default cutoff year of 2049 (i.e., 2000-2099) would mean 2065. Microsoft could have made the explanation clearer by specifying that "a two-digit year value is interpreted as being within the 100-year period ending with the cutoff year." That would make it crystal clear to me that a cutoff year of 2049 means that two-digit year values will be deemed to represent years 1950 - 2049 while a cutoff year of 2074 would mean that two-digit year values will be deemed to represent years 1975 - 2074, etc.Are you sure a century is 1900-1999? I think a century is 1901-2000.I see what you mean... but as the default year starts with 1900 in the SQL I guess what wolfkillj meant might be has to do with this... from 1900 (100 years, including 1900) will be 1999, so 2000 (including 2000) for next century will 2000-2099.(sorry to burst in between)Well, this makes my point even stronger - the word "century" is imprecise in the context of Microsoft's explanation of the cutoff year! Jason WolfkillBlog: SQLSouthTwitter: @SQLSouth
Post #1429421
 Posted Monday, March 11, 2013 4:54 PM
 SSCertifiable Group: General Forum Members Last Login: Yesterday @ 10:06 AM Points: 5,446, Visits: 4,621
 The high standard I came to expect from Ron. Thanks!
Post #1429534
 Posted Tuesday, March 12, 2013 5:20 PM
 SSCrazy Group: General Forum Members Last Login: Tuesday, January 26, 2016 9:10 AM Points: 2,602, Visits: 1,694
 Came to the game late, have been off on a project and too busy to answer anything. Good question and learned something I had never looked into Thanks Not all gray hairs are Dinosaurs!
Post #1430155
 Posted Friday, March 15, 2013 5:27 AM
 SSCoach Group: General Forum Members Last Login: Yesterday @ 1:35 AM Points: 15,510, Visits: 13,170
 Thanks for the question! How to post forum questions.Need an answer? No, you need a question.What’s the deal with Excel & SSIS?Member of LinkedIn. My blog at SQLKover. MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1431466
 Posted Tuesday, March 26, 2013 11:29 PM
 SSCrazy Group: General Forum Members Last Login: Wednesday, December 7, 2016 5:47 PM Points: 2,949, Visits: 1,091
 Thanks for the Question. I figured it out by the fact that the questions were concentrating on 1949-1950.I also use a version of DB2 which uses a Cutoff of 1940 i.e. 1940-01-01 to 2039-12-31 are the valid 2 digit year Dates.
Post #1435771
 Posted Wednesday, April 10, 2013 4:48 AM
 Hall of Fame Group: General Forum Members Last Login: Monday, May 23, 2016 5:31 AM Points: 3,615, Visits: 2,774
 Interesting question.
Post #1440728
 Posted Monday, June 15, 2015 2:42 AM
 UDP Broadcaster Group: General Forum Members Last Login: Friday, December 2, 2016 8:00 AM Points: 1,435, Visits: 367
 Interesting. Thanks
Post #1694502

 Permissions