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 use utf8mb4_unicode_ci in MySQL with PHP?
- How to use a MySQL union in PHP?
- How to change database in MySQL with PHP?
- How to check if a record exists in PHP and MySQL?
- How to generate a UUID in MySQL using PHP?
- How to set a timeout for MySQL query in PHP?
- How to join tables with PHP and MySQL?
- How to create an SSL connection to MySQL using PHP?
- How to fetch data from MySQL in PHP?
See more codes...