title: Timestamp with a millisecond precision: How to save them in MySQL
body: <p>I have to develop a application using MySQL and I have to save values like "1412792828893" which represent a timestamp but with a precision of a millisecond. That is, the amount of milliseconds since 1.1.1970. I declare the row as <code>timestamp</code> but unfortunately this didn't work. All values are set to <code>0000-00-00 00:00:00</code></p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `probability` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `segment_id` int(11) NOT NULL,
  `probability` float NOT NULL,
  `measured_at` timestamp NOT NULL,
  `provider_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
  ) ;
  </code></pre>
  
  <p>How should be the declaration in order to be able to save timestamp values with this precision?</p>