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 |
|
jung1975
Aged Yak Warrior
503 Posts |
 Posted - 2005-08-10 : 13:48:32
|
| How can I convert data format from datetime(01/01/25) to datetime ( 01/01/1925). It keep converting to 2025(year)instead of 1925 (year) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-10 : 13:55:17
|
quote:
By default, SQL Server interprets two-digit years based on a cutoff year of 2049. That is, the two-digit year 49 is interpreted as 2049 and the two-digit year 50 is interpreted as 1950.
What years do you want to be 19nn?Tara |
 |
|
|
jung1975
Aged Yak Warrior
503 Posts |
Posted - 2005-08-10 : 13:56:21
|
| Yes |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-10 : 13:57:24
|
| Yes to what? We need to know which years you want to be 19nn.Tara |
|
|
|
|
|
|
convert data format