title: sql when set default value getdate(), does it set value when run update statement?
body: <p>I know when you insert a value into db, it set that column value as current datetime,
  does it apply to it when you run a update statement?</p>
  
  <p>e.g.</p>
  
  <p>table schema:</p>
  
  <pre><code>Id, Name, CreatedDate(getdate())
  </code></pre>
  
  <p>when i insert into table <code>id = 1 , name = 'john'</code> it will set <code>createdDate = current date</code></p>
  
  <p>if i run an update statement</p>
  
  <pre><code>update table set name="john2" where id =1
  </code></pre>
  
  <p>Will it update the <code>createdDate</code>?</p>