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 |
|
rafaelthirion
Starting Member
2 Posts |
 Posted - 2009-08-28 : 07:52:30
|
| hello guysThe company I work for decided to upgrade its SQL Server from 2000 version to 2008. Everything worked fine in the migration process except for some applications which use the DATEDIFF function.Analysing the problem I verified that what really occurs is that our SQL Server 2008 can´t handle DATEDIFF parameters specified in the British/French standard (DD/MM/YYYY), which is the way we deal with datetimes values in our applications. What really puzzles me is that in the 2000 version the same applications ran smoothly employing the British/French standard.In short, that´s my question: Is there a way to set our SQL Server 2008 to work with this British/French standard for the parameters in datetime functions?I hope anyone can help me.Thanks.Rafael ThirionIT AnalystSao Paulo - Brazil |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-08-28 : 08:38:35
|
| DBCC Useroptionswill tell you what the current date setting isMadhivananFailing to plan is Planning to fail |
 |
|
|
rafaelthirion
Starting Member
2 Posts |
Posted - 2009-08-28 : 09:52:13
|
| ok guysI changed the settings and it worked.Thank you webfred and madhivanan.Rafael ThirionIT AnalystSao Paulo - Brazil |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-08-28 : 13:48:36
|
welcome 
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
datetime formats changes from SQL 2000 to 2008?