title: hive unix timestamp milliseconds
body: <p>I am storing dates as strings, but want to select where the date meets a certain criteria.</p>
  
  <p>Dates look like this ... "2014-10-09 03:59:14.0"</p>
  
  <p>The dates have a millisecond, do I need to remove that millisecond?</p>
  
  <p>This select is running but is not producing the right results.</p>
  
  <pre><code>select EVENT_DT_TM from yv_ipc where unix_timestamp(event_dt_tm,"yyyy-MM-dd HH:mm:ss.S") &gt;         unix_timestamp("2014-10-09 03:59:13.0","yyyy-MM-dd HH:mm:ss.S") limit 10;
  </code></pre>
  
  <p>Thanks for looking.</p>