title: convert string to yyyy-mm-dd
body: <p>I have a Date format in excel like "20.03.2013" i transformed that to "2013-03-20" since this is how the dates look like in my sql-server table. I created a staging table where i gave that field the varchar(15) datatype. now i have to convert that varchar field to a date field but when i check the list of the convert options i cannot find yyy-mmm-dd. <a href="http://www.itrain.de/knowhow/sql/tsql/datum/datumconvert.asp" rel="nofollow">HERE</a> Need help to get my yyyy-mm-dd string to date. </p>