title: Insert Datetime.now from asp.net into sql server
body: <p>I'm trying to insert 'DateTime.Now' into sql column type of datetime but when insert is done in <code>sql</code> table date is OK! (exp: 2015-02-11) but time is stored as 00:00:00!!! I tried to many alternates.
  this is my code:</p>
  
  <pre><code>sqlComm.Parameters.Add("@join_date", SqlDbType.Date).Value = DateTime.Now.ToString("yyyy-MM-dd h:m:s");
  </code></pre>
  
  <p>What am I missing???</p>