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 |
|
jjz
Starting Member
31 Posts |
 Posted - 2010-03-01 : 11:52:01
|
| HiI am trying to execute my store procudure with the following parameter and i get the above error msg:[z_sw2] '2010/12/01 00:00:00','2010/02/31 23:59:59'may someone please advice what is it that i am doing wrong?thank you |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-03-01 : 11:59:35
|
try passing it like below[z_sw2] '2010-12-01T00:00:00','2010-02-31T23:59:59' ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
jjz
Starting Member
31 Posts |
Posted - 2010-03-01 : 12:01:33
|
| still no joy, with the same error msg |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-03-01 : 12:12:22
|
| which locale setting are you using?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Error converting data type varchar to datetime.