title: Hive FROM_UNIXTIME() with milliseconds
body: <p>I have seen enough posts where we divide by 1000 or cast to convert from Milliseconds epoch time to Timestamp. I would like to know how can we retain the Milliseconds piece too in the timestamp. </p>
  
  <p>1440478800123   The last 3 bytes are milliseconds. How do i convert this to something like YYYYMMDDHHMMSS.sss  </p>
  
  <p>I need to capture the millisecond portion also in the converted timestamp</p>
  
  <p>Thanks</p>