title: how to cast a timestamp into a date format in kdb
body: <p>I am trying to cast a column of a timestamp into date format </p>
  
  <h2>eventTimestamp</h2>
  
  <p>2016.11.02D04:25:01.599000000</p>
  
  <p>Into: </p>
  
  <h2>eventTimestamp</h2>
  
  <p>2016.11.02</p>
  
  <p>using <code>update"D"$column from table</code></p>
  
  <p>does not work. I guess I need to parse it out of the string first!</p>