php-mysqlHow to convert a MySQL timestamp to a datetime in PHP?

To convert a MySQL timestamp to a datetime in PHP, you can use the strtotime() function. This function takes a string as an argument and returns a Unix timestamp.

$timestamp = strtotime('2020-02-14 10:00:00');
echo date('Y-m-d H:i:s', $timestamp);

Output example

2020-02-14 10:00:00

Code explanation

• strtotime(): This function takes a string as an argument and returns a Unix timestamp.
• date(): This function takes two arguments, the format of the output and the timestamp.

Helpful links

• PHP strtotime() Function
• PHP date() Function

Edit this code on GitHub