将 PHP 变量"11:00 AM"转换为 MySQL 时间格式?
mysqlmysqli database
使用 DateTime 将 PHP 变量"11:00 AM:"转换为 MySQL 时间格式。
PHP 代码如下 −
$phpTime = '11:00 AM';
echo('The PHP Time Format is =');
echo ($phpTime);
$timeFormat = DateTime::createFromFormat( 'H:i A', $phpTime);
$MySQLTimeFormat = $timeFormat->format( 'H:i:s');
echo ('
');
echo('The MySQL Time Format is =');
echo ($MySQLTimeFormat);
PHP代码快照如下 −
这是输出 −
The PHP Time Format is =11:00 AM The MySQL Time Format is =11:00:00
