Re: change date format in MYSQL

[Aftab Khan]

If your application use PHP then solution is to store the dates in DATETIME fields and use PHPs date() and strtotime() functions to convert between PHP timestamps and MySQL DATETIMEs. The methods would be used as follows -

$mysqldate = date( 'Y-m-d H:i:s', $phpdate );

$q="insert into t1 (....,date) values(....,$mysqldate)";
$phpdate = strtotime( $mysqldate );