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 |
|
Potso6767
Starting Member
18 Posts |
 Posted - 2008-05-05 : 14:05:38
|
| Hi again, I am having troubles inserting a datetime value in a table to a string. what iw ant to do is have it be sent in an email. its an attendance email. here is the code i have right now:select @summaryreport = isnull (@summaryreport + '; ',''+ char(13))+ '<BR>' +'Instructor '+instructor + ' Student ' + Fname + ' ' + Lname + ' - ' + classname +' ' + classdate from #tabledatai get this as an error Msg 241, Level 16, State 1, Line 92Conversion failed when converting datetime from character string. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-05 : 14:08:57
|
| use CONVERT(varchar(11),classdate) |
 |
|
|
|
|
|
Inserting date into string