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 |
|
pramod21
Yak Posting Veteran
64 Posts |
 Posted - 2014-07-28 : 08:07:26
|
| HI, kindly help me out with this error : "The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. "Thanks |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2014-07-28 : 08:26:43
|
quote:
Originally posted by pramod21
HI, kindly help me out with this error : "The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. "Thanks
Means that in your query somewhere you are trying to convert a varchar (i.e. string) to DATETIME data type, but SQL Server was unable to do so. This can happen if the string that cannot be converted to datetime, or if the string is in an unexpected format. Post your query and some sample data if you need more help. |
 |
|
|
|
|
|
datetime error