title: Mysql Unix Timestamp Store?
body: <p>I got a bit of a problem here. My database stores unix timestamps as a string <code>2011-09-01 20:22:36</code> and I need it as a Unix Timestamp ########### so I can compare it using a > then symbol. But I also need to have it automatically set the timestamp on update (<code>ON UPDATE CURRENT TIMESTAMP</code>) as well as have a <code>default of the timestamp</code> <strong>which is not really that important cause I can do that in PHP if I need to.</strong></p>
  
  <p>How can I do this? <code>timestamp</code> is now a date/time combo string and not a integre so I cannot compare it?</p>
  
  <p>My comparison string is</p>
  
  <p><code>$sql = sprintf("SELECT nid, field_date_value, field_movie_location_value FROM content_type_mobile_event WHERE updated&lt;'%s'", $vid);</code></p>
  
  <p>Incase anyone is wondering.</p>