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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-02-04 : 07:12:10
|
| Caroline writes "We have stored procedures that expect smalldatetime parameters. These stored procedures as primarily used by Crystal reports. Everything is fine on our main server which in Standard Edition V7.However, we have a Desktop Edition V7 which we use for testing and I am getting an 8114: error converting datatype varchar to smalldate time for some dates. The dates I have a problem with occur after the 12 day of a month so I guess it's a date format problem. However, I can't see any differences between the setup of the two servers which would cause this problem. I've checked the default language and date format. Just for your information, the date text that Crystal is sending to SQL is like this : '2002-01-13 10:30:00'. It will work for the twelve of the month, e.g. '2002-01-12 10:30:00'. I have tried these parameters in Query Analyser will the same error result. The Standard Edition is on NT4.The Desktop Edition is on a Windows 2000 PC and has had sp4 installed.Do you have any suggestions?" |
|
|
BigRetina
Posting Yak Master
144 Posts |
Posted - 2003-02-04 : 08:05:13
|
| 1.check the date format in the Regional Options.2.Check the language of the Login u are using to log to the DB server |
 |
|
|
|
|
|
Dates as parameters to stored procedures