php-mysqlHow to convert MySQL datetime to string in PHP?
To convert MySQL datetime to string in PHP, the date()
function can be used. This function takes two parameters, the format of the output string and the timestamp. The timestamp can be obtained from the MySQL datetime field using the strtotime()
function.
Example code
$mysql_datetime = '2020-02-14 10:00:00';
$string_date = date('d-m-Y H:i:s', strtotime($mysql_datetime));
echo $string_date;
Output example
14-02-2020 10:00:00
Code explanation
date()
: This function takes two parameters, the format of the output string and the timestamp. It returns a string formatted according to the given format string using the given timestamp or the current local time if no timestamp is given.strtotime()
: This function takes a string as a parameter and returns the corresponding timestamp.
Helpful links
More of Php Mysql
- How to use a variable in a MySQL query using PHP?
- How to change database in MySQL with PHP?
- How to get the version of MySQL using PHP?
- How to create an SSL connection to MySQL using PHP?
- How to update to null value in MySQL using PHP?
- How to use utf8mb4_unicode_ci in MySQL with PHP?
- How to check the result of an insert in PHP and MySQL?
- How to use MySQL transactions in PHP?
- How to get a single value from query in PHP MySQL?
- How to get table column names in PHP MySQL?
See more codes...