Langsung ke konten utama

Postingan

Menampilkan postingan dengan label millenium bug

What Is Ii Digit Yr Cutoff Inwards Sql Server?

Remember the millenium põrnikas fiasco. It happenned inwards Year 2000. This is what chronicled inwards Wikipedia: " The Year 2000 occupation is together with known equally the Y2K problem, the Millennium bug, the Y2K bug, or Y2K. Problems resulted because people, including programmers, reduced the four-digit twelvemonth to ii digits. This made the twelvemonth 2000 indistinguishable from 1900 " Now nosotros convey a amend interpretation for people using ii digit years equally far equally SQL Server is concerned. The default fourth dimension bridge for SQL Server is 1950-2049. Two-digit twelvemonth 49 is 2049, simply ii digit twelvemonth l is dorsum to 1950. Probably y'all volition outset seeing it inwards your credit cards (may be?) You may configure it inwards SQL Server 2017 using, Exec Sp_Configure 'two digit twelvemonth cutoff', 2038 In SQL Server 2012 Express it is enabled past times default: Read to a greater extent than here: https://d...