如何转换要存储在mysql datetime中的日期和时间

Question

How do I convert this to be stored in mysql database with a datetime field?

$phptime = '02/21/2014 9:30 am';

Answer 1

Convert the string to a timestamp, then use the php date function to get it in the format you want.

$datetimeString = date( 'Y-m-d H:i:s', strtotime( $phptime ) );