Home > php_mysql > Convert MySQL date to UNIX timestamp

Convert MySQL date to UNIX timestamp

October 20th, 2008 Leave a comment Go to comments
PLAIN TEXT
PHP:
  1. <?php
  2. // from MySQL to UNIX timestamp
  3. function convert_datetime($str)
  4. {
  5.  
  6. list($date, $time) = explode(' ', $str);
  7. list($year, $month, $day) = explode('-', $date);
  8. list($hour, $minute, $second) = explode(':', $time);
  9.  
  10. $timestamp = mktime($hour, $minute, $second, $month, $day, $year);
  11.  
  12. return $timestamp;
  13. }
  14. ?>

Categories: php_mysql Tags:
  1. No comments yet.
  1. No trackbacks yet.

0 pages viewed, 0 today
0 visits, 0 today
FireStats icon Powered by FireStats