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 |
|
reacha
Starting Member
49 Posts |
 Posted - 2010-12-03 : 11:15:49
|
| when i run one of the procedure i am getting this error..SQL Error: Conversion failed when converting datetime from character string.I need to convert a field from varchar to datetime.Please help me out!!Thanks,reacha |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-12-03 : 11:27:56
|
| The error occurs when you are trying to convert a varchar field to datetime and it could not be converted for some reasons (not a valid value).Can you post the format in which the datetime is stored in the table used in SP? |
 |
|
|
|
|
|
convert to datetime from character string.