Converting a string to datetime from "yyyy-MM-dd"
===

Even though it seems like this question has been asked a bunch of times, I can't seem to find an answer that is specific to my question:

I have a variable that is read from an XML file by a C# XML parser.  It is a string, and is in the format "yyyy-MM-dd".  I would like to read this variable into our database using SQL, but it needs to be in the proper datetime format in order for me to do this.  Unfortunately, I can't find any datetime formats for "yyyy-MM-dd".  Am I missing something?

I would prefer to be able to convert the variable to datetime before I have to open my SQL connection, if possible.