如何在MySQL数据库中以不同的格式保存数据

Question

I notice that MySQL save date as 0000-00-00 format. But in my application I have validate date for this 00-00-0000 format. I notice that date is not saving properly as different formats. Can I change mysql data format to 00-00-0000 format?

Answer 1

The 00-00-0000 format is not entirely clear; it could be dd-mm-yyyy for instance.

You can simply convert the date you have like so:

$mydate = '24-12-2012';
// create date object by using a known format
// see manual page for all format specifiers
$d = DateTime::createFromFormat('d-m-Y', $mydate);

// format date object in yyyy-mm-dd
echo $d->format('Y-m-d'); 

See also: DateTime::createFromFormat() DateTime::format()