Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
vwilsonjr
Starting Member
45 Posts |
Posted - 2002-12-05 : 10:04:28
|
I have a text file that I imported into SQL using DTS. My problem is any date prior to 12/31/49 (source) it shows up as 12/30/2049. How do I resolve this. |
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-12-05 : 10:08:44
|
sp_configure 'two digit year cutoff', '1910'Just set the 2nd argument to match the earliest year your two-digit values can represent. More info on sp_configure in Books Online. |
|
|
vwilsonjr
Starting Member
45 Posts |
Posted - 2002-12-05 : 10:45:47
|
Thanks for you help |
|
|
|
|
|