$re = '/\'(\d{4})(\d{2})(\d{2}) (\d{2}:\d{2}:\d{2})\'/m';
$str = 'INSERT INTO table (field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field)
VALUES (1, \'3110000000\', 2, \'21/01/2011 12:06\', \'1016\', 1, 2, \'asdddasdsd\', \'addasddadsd\', \'adadadaddaddssaddaadddddddsadsd\', \'asdasdsdsdadsadsadadasd\', \'06003160485\', \'adadasdddaddadddds\', \'50124\', \'asdsdaddad\', \'asddasdadsad\', \'03321807576\', NULL, \'20110121 12:07:00\', 1, NULL, NULL, 22),';
$subst = "'$1-$2-$3 $4'";
$result = preg_replace($re, $subst, $str);
echo "The result of the substitution is ".$result;
Please keep in mind that these code samples are automatically generated and are not guaranteed to work. If you find any syntax errors, feel free to submit a bug report. For a full regex reference for PHP, please visit: http://php.net/manual/en/ref.pcre.php