title: How to convert UTC to CST timestamp by retaining the milliseconds in data in Hive
body: <p>I have a hive table in which the data with datatype timestamp is in UTC format. I have created a view on top of this table to convert <code>UTC</code> to <code>CST</code> with daylight savings. That conversion is working fine. But the data is missing milliseconds in it.</p>
  
  <p>The below logic is used in view to convert UTC to CST</p>
  
  <pre><code>FROM_UTC_TIMESTAMP(UNIX_TIMESTAMP(added_date, 'yyyy-MM-dd HH:mm:ss.SSS') * 1000, 'CST6CDT')
  </code></pre>
  
  <p>Please help me to convert <code>UTC</code> to <code>CST</code> including the milliseconds in timestamp.</p>