Is smallDateTime a string? No? Can you put a square into a circle hole? No?<BR><BR>Why in the world would you even *want* to put a string into a date column? If its not a DATE then it shouldnt be a date column. What string were you trying to put in there?
But you have to explain AT WHAT POINT you want to do this.<BR><BR>If you want to do it in the SQL string, you don't have to do anything at all.<BR><BR>Dim SQL As String = "INSERT INTO tablename (smallDateTimeField) VALUES( '3/5/2005' )"<BR><BR>If you mean that you have it already stored in some *other* field as a string, then you just need to use CONVERT:<BR><BR>"UPDATE tablename SET smallDateTimeField = CONVERT(DATETIME, stringField)"<BR><BR>You can also specify a "conversion number" to force TSQL to see the correct version of your date (e.g., does 3/5/2005 means "March 5th" or "May 3rd"?).<BR><BR>"UPDATE tablename SET smallDateTimeField = CONVERT(DATETIME, stringField, 102)"<BR><BR>Where that 102 is changed to whatever makes sense in your environment. See the docs for the CONVERT function to find out what numbers mean what.<BR><BR>If you mean that you want to do this by passing a parameter to a StoredProc, then WHY would you pass it as a string in the first place??? Pass it as a DATETIME value.<BR><BR>But if there is some weird reason to pass it as a string, then again use the CONVERT function.<BR><BR>Next time, give more information so these really easy questions don't end up needing a long answer like this one is.<BR><BR><BR>