How to convert MySQL time to UNIX timestamp using PHP?

by

Use strtotime(..): 

$timestamp = strtotime($mysqltime);
echo date("Y-m-d H:i:s", $timestamp);

Also check this out (to do it in MySQL way.)

http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_unix-timestamp

More Related Contents:

  1. MySQL datetime fields and daylight savings time — how do I reference the “extra” hour?
  2. Using MySQL’s TIMESTAMP vs storing timestamps directly
  3. Formatting an SQL timestamp with PHP
  4. Storing time information: Timezone required?
  5. save user images in MYSQL database by which method? [closed]
  6. Im trying to create some temporary tables in mysql using php
  7. the update query just update the last row and affect other with it’s value
  8. How to insert images into a database using PHP [closed]
  9. How to apply bindValue method in LIMIT clause?
  10. Importing CSV data using PHP/MySQL
  11. Convert latin1 characters on a UTF8 table into UTF8
  12. Find total number of results in mySQL query with offset+limit
  13. mysql_fetch_array() expects parameter 1 to be resource problem [duplicate]
  14. PDO multiple queries
  15. Using strtotime for dates before 1970
  16. How to efficiently find the closest locations nearby a given location
  17. Turn database result into array
  18. NOW() function in PHP
  19. Update query with PDO and MySQL
  20. (mysql, php) How to get auto_increment field value before inserting data?
  21. Trying to get property of non-object – CodeIgniter
  22. PHP to store images in MySQL or not?
  23. UTF-8 character encoding battles json_encode() [duplicate]
  24. Using utf8mb4 with php and mysql
  25. how do I get month from date in mysql
  26. How do I save PHP session data to a database instead of in the file system?
  27. MySQL, how to insert null dates
  28. Escaping SQL queries in Codeigniter
  29. Subtracting a certain number of hours, days, months or years from date
  30. How to write a stored procedure in phpMyAdmin?

Leave a Comment