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 - 2004-06-23 : 10:36:56
|
| Chas writes "Hi Team,I have a MSSQL table with a char(10) column of dates, formated as mm/dd/yyyy. I want to convert this string in an adjacent Datetime column to read the exact same way---mm/dd/yyyy. When I use Convert or cast, I get a buffer overflow error, out of range, or a cannot convert a character string datatype into Datetime message. Help. It may help you to know that I created the orginal mm/dd/yyyy char(10) column by concatenating mm and dd and yyy. Thanks in advance for any help you may offer. Regards,Chas" |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2004-06-23 : 10:36:56
|
| You can use the ISDATE function to return all the rows where it wont' convert to a date. |
 |
|
|
|
|
|
Converting Char to Datetime