Have a look at the different ways to format a date string
Custom Date and Time Format Strings[
^]
[EDIT] Added time information
string strSql = String.Format("SELECT * FROM MYTABLE WHERE DateColumn = '{0}'", dt.ToString("MM/dd/yyyy HH:mm"));
HH will give you values in 24 hour format.
hh will give you values in 12 hour format.