See strtotime and date functions in PHP manual.

$unixTimestamp = strtotime($mysqlDate);
$mysqlDate = date('Y-m-d h:i:s', $unixTimestamp);

• MYSQL: Convert Timestamp --> Time

  I have this MYSQL Table: [ID] [TIMESTAMP] [TIME] [1] [2010-05-29 01:17:35] [] [1] [2010-05-29 01:23:42] [] ... and so on Now I need to copy the TIMESTAMP value into the TIME rows. The new …

• How do I convert this time format?

  2011-07-13 02:38:31 ^ MySQL format. I would like to use PHP to convert it to another format like , July 13, 2011 2:38 am.

• I want to display the current date and time of the users time zone in the format ("Y-m-d H:i:s") PHP

  Possible Duplicate: Timezone conversion in php How to get client's timezone? I want to display the current date and time of the users time zone in the format ("Y-m-d H:i:s") PHP …

• Time completion in working hours

  Okay, not so much a programming problem, but I can only seem to think of really complicated methods to solve this. There is a script we run in the office. We need to determine how long this scrip…

• If I have a PHP string in the format YYYY-DD-MM and a timestamp in MySQL, is there a good way to convert between them?

  I'm interested in doing comparisons between the date string and the MySQL timestamp. However, I'm not seeing an easy conversion. Am I overlooking something obvious?

• How to check if a date has passed

  I am trying to check if a date has passed or if it is the future. If the end_date has passed then I do not want it to display. end_date is a MySQL timestamp. Right now all news articles are displayi…

• How do I extract the number of seconds elapsed from a specific date?

  I want my clients to be able to ask a question on my website, and after 4 days, for that question to be deleted. Everytime that question is visited, for the time elapsed since the question was a…

• How do I get the difference between a mysql timestamp and the php current time?

  The question i guess is kind of 2 questions: How do i even GET the current time in php and in a format that is easily compared to and Once i have that, i have a mysql timestamp in this format…

• How to input the current time into a mysql table from PHP

  I'm using a mysql_query() in PHP to insert a value into a table in a database. One of the attributes of that table is "timestamp" which is supposed to be the current time that the query was made. Ho…

• How can i convert a unix time stamp back to time?

  I have the following unixtimestamps. 1301982430 1301982430 1301981474 1301981466 1301981466 1301981066 1301981058 1301981058 1301980388 1301980373 1301980373 1301979082 1301978478 13019784…