How to update datetime field to contain only the date or time part
<p>How can I update the field that contains the date/time information to contain just the date part of the data?  Something like the following:</p>

<pre><code>update [EVENTS]
  SET [EVENT_DATE] = DATEADD(dd, 0, DATEDIFF(dd, 0, [EVENT_DATE])
  WHERE EVENT_NUM = '8592'
</code></pre>

<p>I also need to get the equivalent to set it to just the time component?</p>