title: SQL Server default date time stamp?
body: <p>I have a field that when something is inserted I want it to get the current Date &amp; Time and insert this into the database. Is there a way to get the date &amp; time, and set it as the default value? </p>
  
  <p>Currently the default value is: (getdate()) Which sets only the date. How do I also set the time? </p>